473,320 Members | 1,862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Querey criteria when you are using check boxes

I want to make a query and the field had check boxes. I want only the checed boxes in the field, not the unchecked boxes. What do I put in the criteria to get this
Jul 7 '15 #1
1 1136
zmbd
5,501 Expert Mod 4TB
Hope Valley,
Start out with the query wizard. It does a fairly good job creating the basic "Select" query.

Once you have that created and saved you can then open the query in design mode.
In the grid section will be your fields.
Under the field with the name of interest, say [CheckMe], there will be a row titled criteria... all entries on the same road are "And" logic, all entries on separate criteria are "or" logic.
Now, under the field, in the criteria row, enter. True, or Yes, or 1, or -1...
Save
Run
only the fields with the check mark will return

( MS Support: Examples of query criteria )


You might find the following interesting:
Allen Browne: Why I stopped using Yes/No fields
Jul 7 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Mohammed Mazid | last post by:
Can anyone please help me on this. I want to use radio buttons and check boxes for this application but how do I store the solutions in MS-Access and then retrieve the values to keep track of the...
3
by: Mohammed Mazid | last post by:
Hi folks! Can anyone please help me with this? I am developing a Quiz program but I am stuck with "multiple answers". Basically I need some sort of code that would select multiple answers...
4
by: Mohammed Mazid | last post by:
Hi folks! Can anyone please help me with this? I am developing a Quiz program but I am stuck with "multiple answers". Basically I need some sort of code that would select multiple answers...
2
by: Ben | last post by:
My current project requires me to create part of a form that is created on the fly. The project consists a list of entries to an event. The name and address and such is easy. The design is detup so...
1
by: jim Bob | last post by:
Again I'm sure this question has been answered somewhere but no luck from the search results. If someone can point me in the right direction that would be cool. I'm trying to build a query where...
2
by: patio | last post by:
MS Access 2007 Form. I need to create either check boxes or a mutivalued list in a form where the user can select more than one item. For example, I am creating a call list that tracks various...
1
by: Stinky Pete | last post by:
Morning, The Non-conformance file we use as part of our Corporate GMP Manufacturing complicance has a number of check boxes that users (7) can select when determining what category a...
7
by: gerryis2000 | last post by:
i have a list box called Items which i want the user to selct items from. how can i make the selection by ticking check boxes rather than pressing ctrl key and the mouse. thank you
3
by: prancer | last post by:
I am new to access and VBA. I would like to use a form to get multiple criteria. FIrstly can I do this from a list? How do you put more than one criteria into a query Secondly if I want to use...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.