Formatting fields on a report

  • Thread starter Thread starter SHAWTY721 via AccessMonster.com
  • Start date Start date
S

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.
 
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."
 
Back
Top