Averaging 4 out of 6 scores

  • Thread starter Thread starter Bill
  • Start date Start date
B

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.
 
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.
Click to expand...

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