Avg of Min

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

 

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