Retrieve all record if check box = 0 (Not checked)
in [Queries]
|
From: Silvio on 27 May 2010 16:32 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
From: vanderghast on 27 May 2010 16:45 You can use the IMP operator: WHERE (FORMS![My Sites Groups]!checkboxName = -1) IMP (Lab = -1) Vanderghast, Access MVP "Silvio" <Silvio(a)discussions.microsoft.com> wrote in message news:DE52CBF2-13C4-48DE-93E6-9CE8B3ABF43C(a)microsoft.com... > 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
From: Silvio on 27 May 2010 16:49 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
From: tighe on 27 May 2010 17:17 Silvio if i am understanding you: 1. the form should have all records. 2. on a form you have an unbound check box where if you check it, only -1 records appear, otherwise all records are visible. if that is correct: on the after update of CheckLab If CheckLab = -1 Then Me.filter = "lab= - 1" Me.FilterOn = True Else: Me.FilterOn = False End If you might have to play around with the quotes in the filter and/or how to handle the else good luck anf i hope that helps "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
From: KARL DEWEY on 27 May 2010 17:47
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 |