Access Report Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2002 and Windows XP

I have data in the detail section of a report which is by quarter and by month. What I want to do is to find the avg of this data over each quarter. I have the data grouped by person and have an unbound field in the group footer. It works but avgs all the data in the detail section. I can't work out how to get it to just avg the data by each quarter. e.g Q1 = july, august, sept. Would love some advise on this please.
 
How about providing some sample output? If you aren't sorting by quarter
then you can't easily get a quarterly average. If this is the case, you may
need to use a subreport based on a totals query.

--
Duane Hookom
MS Access MVP


Kate (NZ) said:
Access 2002 and Windows XP

I have data in the detail section of a report which is by quarter and by
Click to expand...
month. What I want to do is to find the avg of this data over each quarter.
I have the data grouped by person and have an unbound field in the group
footer. It works but avgs all the data in the detail section. I can't work
out how to get it to just avg the data by each quarter. e.g Q1 = july,
august, sept. Would love some advise on this please.
 
Back
Top