Avg of Min

  • Thread starter Thread starter Michael Beatty
  • Start date Start date
M

Michael Beatty

I have a query

Name Opponent Score
Jim New York 50
Slim Atlanta 51
Jim Atlanta 51
Slim New York 50
Jim Atlanta 53
Slim Atlanta 55

I want to average the min for each player
ie
Jim New York 50
Atlanta 51
avg 50.5

Slim New York 50
Atlanta 51
avg 50.5

Any advice?
 
Is there a reason why you couldn't create a recordset of the mins by Name
and opponent and then Group by Name in a report with the average of the min
in the group footer?
 
Back
Top