Sign in to follow this  
Followers 0

How do I get the 4 lowest scores from 6


45 posts in this topic

Posted

I have 6 golfers per team and I want the 4 lowest scores from each team to be a total team score, but I don't want to click any buttons, just enter each players hole scores and once the total 9 hole score is calculated for all six golfers it ranks them. I understand that there may be scores with the same value (40,36,40,42,52,43) end result (36,40,40,42= 158).

0

Share this post


Link to post
Share on other sites

Posted

I have 6 golfers per team and I want the 4 lowest scores from each team to be a total team score, but I don't want to click any buttons, just enter each players hole scores and once the total 9 hole score is calculated for all six golfers it ranks them. I understand that there may be scores with the same value (40,36,40,42,52,43) end result (36,40,40,42= 158).

0

Share this post


Link to post
Share on other sites

Posted

I have 6 golfers per team and I want the 4 lowest scores from each team to be a total team score, but I don't want to click any buttons, just enter each players hole scores and once the total 9 hole score is calculated for all six golfers it ranks them. I understand that there may be scores with the same value (40,36,40,42,52,43) end result (36,40,40,42= 158).

0

Share this post


Link to post
Share on other sites

Posted

Make a caluclated field = Score & " " & GolferID, were GolerID is an unique serial number. Use this field to make a related value list. Then use ValueListItems to make a list of the golfer scores & Id's Pick the top four scores off the list.

0

Share this post


Link to post
Share on other sites

Posted

Make a caluclated field = Score & " " & GolferID, were GolerID is an unique serial number. Use this field to make a related value list. Then use ValueListItems to make a list of the golfer scores & Id's Pick the top four scores off the list.

0

Share this post


Link to post
Share on other sites

Posted

Make a caluclated field = Score & " " & GolferID, were GolerID is an unique serial number. Use this field to make a related value list. Then use ValueListItems to make a list of the golfer scores & Id's Pick the top four scores off the list.

0

Share this post


Link to post
Share on other sites

Posted

Thanks so much, is there anywhere I can find an example close to this, because I'm a beginner and this makes sense but I'm not sure how to go about this.

0

Share this post


Link to post
Share on other sites

Posted

Thanks so much, is there anywhere I can find an example close to this, because I'm a beginner and this makes sense but I'm not sure how to go about this.

0

Share this post


Link to post
Share on other sites

Posted

Thanks so much, is there anywhere I can find an example close to this, because I'm a beginner and this makes sense but I'm not sure how to go about this.

0

Share this post


Link to post
Share on other sites

Posted

What do you have so far? Can you post a sample of your database? I could make a sample but it would be easier to build on what you have.

0

Share this post


Link to post
Share on other sites

Posted

What do you have so far? Can you post a sample of your database? I could make a sample but it would be easier to build on what you have.

0

Share this post


Link to post
Share on other sites

Posted

What do you have so far? Can you post a sample of your database? I could make a sample but it would be easier to build on what you have.

0

Share this post


Link to post
Share on other sites

Posted

Since I haven't hear from you I put together a sample file.

0

Share this post


Link to post
Share on other sites

Posted

Since I haven't hear from you I put together a sample file.

0

Share this post


Link to post
Share on other sites

Posted

Since I haven't hear from you I put together a sample file.

0

Share this post


Link to post
Share on other sites

Posted

I hope this makes sense to you. Again thanks.

0

Share this post


Link to post
Share on other sites

Posted

I hope this makes sense to you. Again thanks.

0

Share this post


Link to post
Share on other sites

Posted

I hope this makes sense to you. Again thanks.

1110296184-Picture1.pdf

0

Share this post


Link to post
Share on other sites

Posted

I have modified my file to display like your example.

0

Share this post


Link to post
Share on other sites

Posted

I have modified my file to display like your example.

0

Share this post


Link to post
Share on other sites

Posted

I have modified my file to display like your example.

0

Share this post


Link to post
Share on other sites

Posted

He is my file, the one you made looks great and works great, but I would like to print this off when the golf meets are done without all of the extra fields. Thanks much

0

Share this post


Link to post
Share on other sites

Posted

He is my file, the one you made looks great and works great, but I would like to print this off when the golf meets are done without all of the extra fields. Thanks much

0

Share this post


Link to post
Share on other sites

Posted

He is my file, the one you made looks great and works great, but I would like to print this off when the golf meets are done without all of the extra fields. Thanks much

0

Share this post


Link to post
Share on other sites

Posted

Did our files pass each other? I think the last one I sent is almost what you want.

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0