SQL - select UNIQUE

[turfbult]

Hi,

I have an access db with a table hotels and want to fill a combo box with all the UNIQUE states in that table.

The table has many hotels in the same state!!

I tried ..

ssql = "select unique (states) as states from hotels"

but I get the error "undefined function 'unique' in expresion"

Can someone please tell me how this is done!!

Thank you.

[JHausmann]

Try "distinct" in place of "unique".

[turfbult]

Thanks you,

"distinct" works!!!