Select Query That Doesn't Show Duplicates

[knighty03]

I want to create a select query whereby it will show all records but will show only 1 record of a duplicate e.g. I might have say "FORD" entered in three times but in the query I would want it to show only one of these as it is not important how many times it has been entered. Any help would be grateful.

 

[SuicidED]

Hi use

SELECT DISTINCT Table1.period
FROM Table1;
where Table1 is your table name and period your field name

 

[JoeEskimo]

Also you could set the Unique Values option in PROPERTIES of the query.