Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping by month??

Status
Not open for further replies.

Eightball3

Programmer
Nov 23, 2002
138
US
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top