grouping

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.
 
M

Marshall Barton

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Incone & Expenses Statement 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Need Help with a VBA subroutine 0
Countdown macro - display settings 2
Synchronization problems while moving folders to new email 1
Dsum and Dmax with structured references 1
Group Totals and Grand Totals on each page 3

Top