duplicate values returned

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Russ - 30 Jun 2005 13:43 GMT

Hi,
I have a query based on 2 tables "Diagnosis Table new" and "Dx Classification"

There are several fields in teh queries, but the important fields are
"ICD_Code", "Site", and "TypeOfInjury"

There are several values that are the same for "ICD_Code" which have
different values for either Site and TypeOfInjury.
ie.
ICD_Code Site TypeOfInjury
34 Knee Arthritis
34 Knee Fracture
34 Knee Soft Tissue
34 Hip Arthritis

I want the ICD_Code to be returned when i query for Knee or hip, but i dont
want it to be in teh query 3 times under knee.
so basically the ICD_Code and the Site should only appear together one time.
how do i accomplish this?
thank you very much for your help.

russ

Signature

Russ

Reply to this Message

Dennis - 30 Jun 2005 15:05 GMT

Can you create a new query with just the ICD_Code and Site as the columns ?
If yes, then you can just click on the totals button and it will group by
ICD_Code and Site to give 2 rows returned for code 34.
If your existing query has criteria on the other fields, then base your new
query on this query and perform the same selection as above.

> Hi,
> I have a query based on 2 tables "Diagnosis Table new" and "Dx Classification"
[quoted text clipped - 18 lines]
>
> russ

Reply to this Message