Avg of Min

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?
 
D

Duane Hookom

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?
 
Top