data grouping

T

Thanes

I have a report that is grouped by AUDITMTH and COMPLETE
AUDITMTH is a date entered when the user first opens the report and COMPLETE
is the month ("mmmm") the audit was completed. The report is as follows:

AUDITOR: BRADSHAW
October
My Company COMPLETE: 10/2/2003

However, as the report does group the audits by month it doesn't list all
the audits for the specific month in one. It separates them by the year from
the COMPLETE field. How do i make it so that all the records are grouped by
the month regardless of the year?
 
F

Fons Ponsioen

You can sort/group by
Month([AUDITMTH])
and the same for Month([COMPLETE])
or combined :
Month([AUDITMTH])& Month([COMPLETE])
This wil sort/group regardless of year.
Maybe with some more records showing how the report is
listing them and how you want them I can help you more.
Fons
 
Top