# How do I get the 4 lowest scores from 6

## Recommended Posts

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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

##### Share on other sites

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

##### Share on other sites

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

##### Share on other sites

I hope this makes sense to you. Again thanks.

##### Share on other sites

I hope this makes sense to you. Again thanks.

##### Share on other sites

I hope this makes sense to you. Again thanks.

Picture1.pdf

##### Share on other sites

I have modified my file to display like your example.

##### Share on other sites

I have modified my file to display like your example.

##### Share on other sites

I have modified my file to display like your example.

##### Share on other sites

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 on other sites

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 on other sites

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 on other sites

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

##### Share on other sites

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

##### Share on other sites

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

##### Share on other sites

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

##### Share on other sites

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

##### Share on other sites

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

##### Share on other sites

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 on other sites

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 on other sites

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 on other sites

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 on other sites

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.

## Create an account

Register a new account