Full Version: yes/no box where clause comparison
UtterAccess Forums > Microsoft® Access > Access Forms
teq
hello,
Am wondering how i compare the data type yes/no which is in my table
i've tried AND [comp] = No, and [comp] = False, etc but to no avail
any ideas??
BrianS
True/False should work. Can you post the entire comparison (sql string) you are trying?
ScottGem
The actual value stored in a Yes/No field is 0 for no and -1 for Yes. Any of these should work:
Comp] = 0
[Comp] = False
[Comp] = No
For the reverse:
[Comp] = -1
[Comp] = True
[Comp] = Yes
teq
ahh right you are brian. the problem was a different part of my statement which i didnt realize.. thanks alot for your help
BrianS
No problem, glad to help
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.