Total months

[chrissy2391]

I'm trying to create a report that groups by school and then totals up the
actual cost field per school for each month. What's throwing me off is the
fact that the completed dates are entered in the format 10/10/05. How can I
get a total for each month, a YTD total for each school, and then a report
total of all school. I appreciate any help on this.

 

[Jeff Boyce]

You could create a Totals query, grouping by the month. To get the month,
you could use the Month() function, something like:

MyMonth: Month([MyDateField])

in an underlying query.

To find a YTD range of dates, you could use the DateSerial() function, along
with today's date (via the Date() function).

Regards

Jeff Boyce
<Office/Access MVP>