How do I Average a group and not entire Query in Reports?

[HuntinHippy]

I am using Access 2007 and I am trying to average a group of costs but when I
do the count comes up as the entire query instead of the group in the report
and only accounts for the cost in the first line of the group.

 

[John W. Vinson]

I am using Access 2007 and I am trying to average a group of costs but when I
do the count comes up as the entire query instead of the group in the report
and only accounts for the cost in the first line of the group.

Since you don't describe what you're doing, it becomes a bit difficult to say
what you're doing wrong. You can use the Report's "Sorting and Grouping"
dialog to break the data into groups, and do your sums and averages in the
group footer. Would that help?