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)
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 |
#2
|
|||
|
|||
Retrieve all record if check box = 0 (Not checked)
You can use the IMP operator:
WHERE (FORMS![My Sites Groups]!checkboxName = -1) IMP (Lab = -1) Vanderghast, Access MVP "Silvio" wrote in message news 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 |
#3
|
|||
|
|||
Retrieve all record if check box = 0 (Not checked)
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 |
#4
|
|||
|
|||
Retrieve all record if check box = 0 (Not checked)
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 |
#5
|
|||
|
|||
Retrieve all record if check box = 0 (Not checked)
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 |
#6
|
|||
|
|||
Retrieve all record if check box = 0 (Not checked)
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 |
Thread Tools | |
Display Modes | |
|
|