I Need Help

X

xeb

In Access 2000, in a report, I need to calculate the average for eac
day of the week. In other words, I need the average of all "Monday
records, all "Tuesday" records, etc.

What would the expression be
 
D

Duane Hookom

I would create a totals query that groups by day of the week and averages
your field. Then create a subreport based on totals query.
 
Top