SELECT unique field for combobox

[startup]

Hello,

I have a table with values like the following in one of the columns:

AA
AA
BB
CC
CC
CC
EE

How would I create a SELECT statement which would grab a unique instance of each field? The resulting output I want would be:

AA
BB
CC
EE

Thanks,
Rico

 

[allanon]

SELECT DISTINCT table1.field1
FROM table1

 

[startup]

Thanks, just what I needed.