Group Birthdays By Month

[Greaser]

Hi,
Can anyone help me with the following?
I want to create a report that will show people's birthdays grouped by month.
I have a table that contain the following fields:
[Name]
[DateOfBirth]
I also want the group header to show the relevant month.
Thanks,
John

 

[MichaelRed]

CReate a temp field (ref "MnthBorn&quot in an aggreagate query.

[tab]MnthBorn: Month([DateOfBirth])

Set the aggregate to Groupby for this field

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over