Reporting on people with the same date of birth 3

[awhawh]

Hi,

Can someone advise me as to the best way to identify people on a database with the same date of birth?

Thank you

Adam

 

[IanWaterman]

List employees and then add a group using DOB field

Ian

 

[awhawh]

Excellant, thanks your help Ian.

 

[lbass]

If you really mean the "same birthday", group on a formula like this:

month({table.DOB}) & "/" & day({table.DOB})

-LB

 

[Madawc]

You probably don't want to see 'groups' with just one member. If you do a summary count, you can then use group selection to suppress those where the count is 1.

The use of Crystal's automated totals is outlined at FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[awhawh]

Thanks for all your replies. They are all very helpful