Add the field to the query design grid
Type True in the criteria line. this will get all check boxes that are true.
Jim Wagner
________________________________
________________________________
From: mahinalanibaker <mahinalanibaker@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, August 28, 2013 8:59 AM
Subject: [MS_AccessPros] How do I do a query with yes/no boxes?
I have several yes/no boxes in my forms. I want to make queries based on
if the boxes are checked or not. How do I do that? When I deselct the
boxes in the query it still shows the information. What if I don't want
it to show at all. I don't need that infor for this particular query.
Help please! I'm using Access 2007. Thank you so much in advance.
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar