Grouping by month??

[Eightball3]

I have a report I'm building. I would like the report to group by month of date field that I have. I know that I use the Date field in the sorting and grouping screen but how? The report could span across a few years so I would like Jan, Feb, Mar,.....Dec, Jan, Feb, etc. So...I guess I would group by Month/Year. How would I do this? Thanks.

 

[randysmid]

Hi,
As you know, your date field will include the month, day and year. With this in mind, Access will automatically group the data by the appropriate month and year.
You can set all of this up by clicking on "Group On" in the Sorting and Grouping window. The options available to you are dependent on the datatype. So, a date field will give you a number of unique grouping options, including "Year", "Qtr", "Month", "Week", "Day", "Hour", and "Minute". HTH,
Randy Smith
California Teachers Association