Query that will show only one of duplicate records. (1 Viewer)

[popen]

What I am wracking my brains over is this:

I have a query that will pull off Patient ID's and Their Referral Type. Simple enough.

Now, there may sometimes be more than one referral type against any one patient ID.

AND there may be records that contain the Patient ID with the same Referral type.

Example:

This may be what the query will produce:

Patient ID Referral Type
123456 7
123456 8
123456 7

What I need to do is only have a the referral type appear ONCE against a Patient ID, Such as:

PATIENT ID Referral Type
123456 7
123456 8


See what I am trying to get at?

As it is Friday, I need HELP !

Many thanks.

 

[popen]

Nevermind, just had a brain wave.................. I'll use Unique Query property.