Average in footer

R

Ray S.

I want to average a detail column in a group footer section by the group.
Let's say the detail column is [Wage] and the group is [Department]. I've
created an unbound textbox in the group footer, but everything I've tried
turns up weird and wrong results. Can I get a tip on this?
 
O

Ofer

Have you try writing in the Control source of the field in the footer that
contain the Average

=Avg([Wage])
 
Top