Sort report by month not year

  • Thread starter Thread starter Catherine
  • Start date Start date
C

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
 
Catherine said:
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.
Click to expand...


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
 
It works! Thank you Marsh

Catherine :)
-----Original Message-----
Catherine said:
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.
Click to expand...


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
Click to expand...
 
Back
Top