Sorting by year

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

I would like to sort a report by the year of purchase. I have a report that
sorts by date and gives me a total for each period. The report is grouping
by month and I want to group by year. Any suggestions?
 
I would like to sort a report by the year of purchase. I have a report that
sorts by date and gives me a total for each period. The report is grouping
by month and I want to group by year. Any suggestions?
Click to expand...

Correct the query upon which the report is based (and which you chose not to
post, so we cannot see it to help you do so).

My only guess is that you're -somewere - using a calculated field like
Month([datefield]), and you need to change it to Year([datefield]).

Open the report's Recordsource query, select View... SQL, and post the SQL
text here if you need help.
 
Open report in design view, click on Sorting and Grouping and select your
date field.
Format the date field like ---
=Format([YourDateField], "yyyy")

Set a group header/footer.
 
Back
Top