SQL statement for a Combobox

[Beany]

I have a combobox that has a list of sites.......... ...

selecting a site brings up all the site details in a form........... .......

there are several fields within that form including a status field.

The status field includes live, cancelled, pending .

What i want to do is, if any site has a status of cancelled , it shouldnt list it in the combobox....... ........how do i do this?

ive tried the following SQL statement...... .... it doesnt work

SELECT [tab_data].[site] FROM tab_data WHERE status != cancelled  ORDER BY [site];

[NeoPa]

Try :

SELECT [Site] FROM [tab_data] WHERE UCase([Status])<>'CANCELLED' ORDER BY [Site]

[Beany]

Thanks Neo,

that works.........