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).

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).

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).

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.

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.

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.

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.

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.

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.

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.

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.

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.

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Posted

I hope this makes sense to you. Again thanks.

Share this post


Link to post
Share on other sites

Posted

I hope this makes sense to you. Again thanks.

Share this post


Link to post
Share on other sites

Posted

I hope this makes sense to you. Again thanks.

Picture1.pdf

Share this post


Link to post
Share on other sites

Posted

I have modified my file to display like your example.

Share this post


Link to post
Share on other sites

Posted

I have modified my file to display like your example.

Share this post


Link to post
Share on other sites

Posted

I have modified my file to display like your example.

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

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

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

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.

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.

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.

Share this post


Link to post
Share on other sites

Posted

yes the files must have passed, I will check it out.

Share this post


Link to post
Share on other sites

Posted

yes the files must have passed, I will check it out.

Share this post


Link to post
Share on other sites

Posted

yes the files must have passed, I will check it out.

Share this post


Link to post
Share on other sites

Posted

It's almost perfect. The new one you sent me doesn't have a team score. Thanks Ralph.

How can you enter all of that data in such a short time.

Share this post


Link to post
Share on other sites

Posted

It's almost perfect. The new one you sent me doesn't have a team score. Thanks Ralph.

How can you enter all of that data in such a short time.

Share this post


Link to post
Share on other sites

Posted

It's almost perfect. The new one you sent me doesn't have a team score. Thanks Ralph.

How can you enter all of that data in such a short time.

Share this post


Link to post
Share on other sites

Posted

It did when it left here. On the layout Score Card it is under the center 2 columns. I didn't think that 9s fast. Once I had one portal laid out I used duplicate to make the next 5 and then changed the starting portal row in each.

Share this post


Link to post
Share on other sites

Posted

It did when it left here. On the layout Score Card it is under the center 2 columns. I didn't think that 9s fast. Once I had one portal laid out I used duplicate to make the next 5 and then changed the starting portal row in each.

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