Month on Report

  • Thread starter Thread starter Ray via AccessMonster.com
  • Start date Start date
R

Ray via AccessMonster.com

I have a query that has submit dates... 9/3/2007, 10/15/2007, etc. I need a
way to group all dates together for one month and label it as September or
October, etc.

So, on my report, I have a field called month. I'd like to group the dates
and then on change in the dates, change the field month to September with a
list of those dates, and then October for the group of October dates. Not
sure if I should use a field or just use a label and change the lable. The
only thing is I don't think I can group on a label in the report.

Example Report:
September
9/1/2007
9/3/2007
9/12/2007

October
10/5/2007
10/7/2007

Does anyone have the best way to do this?

Thanks,
Ray
 
The sorting and grouping dialog in Access reports allow you to specify the
date field and set the interval to Month. You might also need to set the
higher level sorting and grouping interval to Year.
 
Great Duane. Thanks!

Still trying to change the label to the month name each time the month
grouping changes.

Ray

Duane said:
The sorting and grouping dialog in Access reports allow you to specify the
date field and set the interval to Month. You might also need to set the
higher level sorting and grouping interval to Year.
I have a query that has submit dates... 9/3/2007, 10/15/2007, etc. I need a
way to group all dates together for one month and label it as September or
Click to expand...
[quoted text clipped - 20 lines]
Thanks,
Ray
Click to expand...
Click to expand...
 
Use a text box bound to your date field and set its Format property to MMMM
or MMM.
--
Duane Hookom
Microsoft Access MVP


Ray via AccessMonster.com said:
Great Duane. Thanks!

Still trying to change the label to the month name each time the month
grouping changes.

Ray

Duane said:
The sorting and grouping dialog in Access reports allow you to specify the
date field and set the interval to Month. You might also need to set the
higher level sorting and grouping interval to Year.
I have a query that has submit dates... 9/3/2007, 10/15/2007, etc. I need a
way to group all dates together for one month and label it as September or
Click to expand...
[quoted text clipped - 20 lines]
Thanks,
Ray
Click to expand...
Click to expand...
Click to expand...
 
Back
Top