Formatting fields on a report

[SHAWTY721 via AccessMonster.com]

I have a report that I need to list totals by month by there account code &
sub account. I have a query that generates all the necessary information but
I am having a issue converting a field "Check Date" to be the month and then
have the associated months listed at the top of the form along with the
corresponding totals for each field necessary.

 

[Al Campagna]

Shawty,
MonthDate = Month([CheckDate]) yields a sortable number 1 to 12
YearDate = Year([CheckDate]) yields a sortable number in the form yyyy.
These values should be included in your report query, and Sort & Group
on YearDate(asc) and MonthDate(asc).

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."