Averaging 4 out of 6 scores

[Bill]

How do I average the lowest of 4 out of 6 scores in my database record? I
store all 6 scores but only want the 4 lowest to be averaged into an AvgScore
field in the same record, same database.

 

[John W. Vinson]

How do I average the lowest of 4 out of 6 scores in my database record? I
store all 6 scores but only want the 4 lowest to be averaged into an AvgScore
field in the same record, same database.

Use the TOP VALUES property in a Totals query. See the help for TOP.