how to <ALL>

[icemonster]

hi, i have a combo box that is used to filter a sql statement, that combo box is from a table, i once saw a sample (can't find it anymore) that had the option to have an ALL or 0 choice so you can view everything or just the records with 0 or null on that field.

how do i do that as an sql statement or otherwise?

 

[gemma-the-husky]

you need a union query

union your query with another that has say 0,"<ALL>" as columns. (The column counts have to match.

this query will then give you anoither selection row of 0, with text <ALL>

you still need to modify your query to select rows appropriately, when you select the ALL option.