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