Removing duplicates from a query

[Martina]

I am running a query to return records from a table. I want to eliminate records from the query if the values contained in one field are duplicated. I have tried using the DISTINCT keyword but it only works if the entire record is unique or if I was retieving just one field

Any suggestions appreciated

 

[FoFa]

Use group by, it allows to group on a single field. Downside, you have to decide to return min or max of the other fields. Of course by removing dups on a single field, how do you determine which of the other none duplicated fields you care about if the data differes?