Check Box in Table for Query....

[jock95]

I am needing to run a query based on whether a check box is checked or not. What is the code to do that?
"Is Not Null" does not work.

Thank you,

 

[PHV]

The value of a CheckBox object is a Boolean, so you test against Trye/False or Yes/No Or -1/0

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bosk00]

You can check for 0 for unchecked and -1 for checked.

Alan
Senility at its finest

 

[traingamer]

WHERE ((([ckboxfiled])=True));


traingamer