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
Expand|Select|Wrap|Line Numbers
- SELECT [tab_data].[site] FROM tab_data WHERE status != cancelled ORDER BY [site];