Prev: Parameter Query Using Combo Box
Next: Joins on NULL Date values
From: John Spencer on 28 May 2010 11:24
WHERE Lab = [Forms]![My Sites Groups]![CheckLab] OR Lab = -1

If Checklab is checked you will see all records where Lab is True. If
checklab is not checked you will see all records where Lab is False (0) plus
all records where Lab is True (-1)

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

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
First  |  Prev  | 
Pages: 1 2
Prev: Parameter Query Using Combo Box
Next: Joins on NULL Date values