Skip to Content
Former Member
May 17, 2005 at 09:08 PM

Suppressing repeated records in the query


Hello Gurus,

I have a Doctor#1 treating Patient#1 in 3 different cases and in the report I just need to see 1 instead of 3 as it is the same patient#1 to the same doctor#1. What are the ways I can manipulate this data without writing any program.

Report shows as follows: records

doctor 1 disease 1 patient 1 1

disease 2 patient 1 1

disease 3 patient 1 1

total 3

Any help i.e can I write conditions? Selections? or any idea would be greatly appreciated.