Formula For Duplicate Records

[JM3482]

I need a formula that pulls duplicate records based on a patient number field that I use in a table. Below is what I currently pull in Access but need to have it converted over to crystal.

In (SELECT [PATIENT_NO] FROM [find duplicates STD STD LOC] As Tmp GROUP BY [PATIENT_NO],[Admit Date] HAVING Count(*)>1 And [Admit Date] = [find duplicates STD STD LOC].[Admit Date])

 

[Madawc]

In Crystal 8.5, you can group by patient number. Show details in the group footer, include a count of records and suppress those with a count of 1.

Madawc Williams
East Anglia, Great Britain