'SHOW ONE RECORD ONLY' QUERY

[fsweb2002]

Hi

I am really going blank today...

I have a query which shows many records, one of the fields (country_Code) being duplicated many times (all other fields are different though).

I need to create a report/query which will only show as many records as there are country_codes, without duplicates on the country_code.

Can anyone help ???

Thanks

 

[Quehay]

SELECT DISTINCT col1, col2
from tables
order by col1 etc.

OR:

Don't worry about dups in the query. Using grouping in the report to show country header once, with pertinent records below.

 

[fsweb2002]

Thanks Quehay!
Works fine
regards