If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Retrieve all record if check box = 0 (Not checked)
Try this --
SELECT tblSite.Site, tblSite.Lab FROM tblSite WHERE tblSite.Lab = IIF([Forms]![My Sites Groups]![CheckLab] = 0, Between -1 AND 0, -1); -- Build a little, test a little. "Silvio" wrote: Hi Karl thanks for the replay. The check Box located on the form is unbounded and the values will always be either 0 or 1, never Null. Therefore, if the check box is 0 then I want to be able to retrieve record 0 and -1, if the check box is -1 then I want to retrieve only record with -1. "KARL DEWEY" wrote: If the checkbox is neith 0 or -1 then it is null. Try this -- SELECT tblSite.Site, tblSite.Lab FROM tblSite WHERE tblSite.Lab = IIF([Forms]![My Sites Groups]![CheckLab] Is Null, Between -1 AND 0, [Forms]![My Sites Groups]![CheckLab]); -- Build a little, test a little. "Silvio" wrote: Hello, I would like to see ALL (0 and -1) records if my check box in my form is not checked (0) and if checked (-1) I would like to see only record with -1 (with check mark) This is what I have, but as expected it will return only record with 0 OR -1 SELECT tblSite.Site, tblSite.Lab FROM tblSite WHERE (((tblSite.Lab)=[Forms]![My Sites Groups]![CheckLab])); Thank you, Silvio |
Thread Tools | |
Display Modes | |
|
|