Count of people with the same birthday

[jess]

I've got a date field...with values such as

9/1/1934

12/11/1966

How would I count the number of people that have the same birthday, by date...meaning create a report that provides an export like this:

9/1 312

9/2 278

9/3 289

I know how to do sub-summary reports...but its finding and sorting thats giving me fits. Do I have to break up the date of birth field first to narrow down my set? Ultimately I will have to do an export of all these people who's birthday land on the same day and do a mail merge.

I'm using FM8

Thx...

Edited August 17, 2006 by Guest

[comment]

You need a break field that will have a common value for "all these people who's birthday land on the same day".

Try a calculation field (result is Date) =

Date ( Month ( BirthDate ) ; Day ( BirthDate ) ; 4 )

Sort and summarize by this field. In Layout mode, format the field to display Month/Day only.