Report by Month (Access 2003)

Topic

New Reply

I started this report and its getting out of control:

The Query has Fields: WeeklyUpdate | UpdateWeek (This is a date field MM/DD/YYYY)

I wanted to show the Month so I can sort the report by month so I used:
MonthName(Month([UpDate Week]) to get the Months: February, April, etc

My problem is, how do I create a query for a report…. where the report will sort by Month — Decending, then by WeeklyUpdate Item.

Thanks

Reply | Quote

Replies

Try Format(UpdateWeek,”mmmm”) in a new column to get your months sorted decending. Place this column before the WeeklyUpdate column so it sorts first. The use the query for your report.

Reply | Quote

It doesn’t matter how you sort in the query, the report will ignore the queries sorting.
Youdefine the report’s sorting in the design view of the report then choose View/Sorting and Grouping.

Reply | Quote

I assume that you want to sort by month chronologically, not alphabetically by name. If you sort on month names, you’d get

April, August, December, February, January, …

if you sort ascending, and the reverse if you sort descending. If you want to sort as

January, February, March, April, May, …

or the reverse, you should use

TheMonth: Month([UpDateWeek])

As Patt wrote, you have to specify the sort order for the report in the Sorting and Grouping window in the report design.

Reply | Quote