access query criteria

[kitaeshi]

Hi all for query criteria. I have a field which is Yes/No.

i set criteria 0, it will select those with No value or those which is not check. but if i set criteria to 1, nothing will be selected. how come?

tks for reading.

 

[boblarson]

Trues are -1 not 1

 

[kitaeshi]

oh i c thks. as i new to access..

 

[Moniker]

Easy way to figure this out (Ctrl-G is the immediate window in Access).

 

[gemma-the-husky]

but you are safer testing for "true" or "false" rather than arbitrary values

 

[boblarson]

but you are safer testing for "true" or "false" rather than arbitrary values

Not arbitrary values - in fact they are constants represented by TRUE or FALSE.