Retrieve all record if check box = 0 (Not checked)
in [Queries]
|
Prev: aggregate calculation works in select query but not an update quer
Next: Parameter Error for Year 2010
From: KARL DEWEY on 27 May 2010 15:53 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 |