grouping

  • Thread starter Thread starter John
  • Start date Start date
J

John

Data is in a table by a specific date (12/15/03). Is it
possible to group this data in a report by month? Then
total the data for a specific month? I've tried selecting
sorting/grouping but it did it by its specific date and
I've tried using left$([date],2) which also did not work.
 
John said:
Data is in a table by a specific date (12/15/03). Is it
possible to group this data in a report by month? Then
total the data for a specific month? I've tried selecting
sorting/grouping but it did it by its specific date and
I've tried using left$([date],2) which also did not work.
Click to expand...


In Sorting and Grouping, set the GroupOn to Month.

Alternatively, instead of grouping on the date field, group
on the expression:
=Format(datefield, "yyyymm")
 
Back
Top