RE: duplicate values returned

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.

"Russ" wrote:

> 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
> --
> Russ
.