Sort report by month not year

[Catherine]

Hi, I am quite new to Access and self taught so can't cope
with answers suggesting complex code. I'm using Access 97
and Access 2000. Don't ask!

I am wanting to sort a report of birthdays by month ie. I
want all the Jan birthdays together irrespective of the
birth year etc.

I have already tried only displaying day and month through
the format property and I have set sorting and grouping to
sort by "date of birth", group on month. But no luck.

Any ideas?

Catherine

 

[Marshall Barton]

Hi, I am quite new to Access and self taught so can't cope
with answers suggesting complex code. I'm using Access 97
and Access 2000. Don't ask!

I am wanting to sort a report of birthdays by month ie. I
want all the Jan birthdays together irrespective of the
birth year etc.

I have already tried only displaying day and month through
the format property and I have set sorting and grouping to
sort by "date of birth", group on month. But no luck.

It's still using the year part of the date so you're getting
each month (that has a bithday) in each year.

Try changing the group to:

=Month([date of birth])

and each value instead of on month.

You've probably already figured this out, but you can
display the name of the month in the group header section by
using a text box bound to [date of birth] with the format
property set to mmmm

 

[Catherine]

It works! Thank you Marsh

Catherine

-----Original Message-----

Hi, I am quite new to Access and self taught so can't cope
with answers suggesting complex code. I'm using Access 97
and Access 2000. Don't ask!

I am wanting to sort a report of birthdays by month ie. I
want all the Jan birthdays together irrespective of the
birth year etc.

I have already tried only displaying day and month through
the format property and I have set sorting and grouping to
sort by "date of birth", group on month. But no luck.

It's still using the year part of the date so you're getting
each month (that has a bithday) in each year.

Try changing the group to:

=Month([date of birth])

and each value instead of on month.

You've probably already figured this out, but you can
display the name of the month in the group header section by
using a text box bound to [date of birth] with the format
property set to mmmm