Month on Report

[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

 

[Duane Hookom]

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.

 

[Ray via AccessMonster.com]

Great Duane. Thanks!

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

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.

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

[quoted text clipped - 20 lines]

Thanks,
Ray

 

[Duane Hookom]

Use a text box bound to your date field and set its Format property to MMMM
or MMM.
--
Duane Hookom
Microsoft Access MVP

Great Duane. Thanks!

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

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.

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

[quoted text clipped - 20 lines]

Thanks,
Ray