I made a database on a survey that I want my agency to fill out and return. I need to know how many checked off yes for each question. I can't figure out how to run the query to get the count of all of the check marks.
Please help!
Please help!
Running a Query on the check boxes
- Thread starter hunsyci
- Start date
ted.martin
Registered User.
- Local time
- Today, 17:40
- Joined
- Sep 24, 2004
- Messages
- 743
Make a test Query1 with one check box field from your data and make the filter criteria = true.
Next make another query2 based on the one above where there is only one field in the QBE grid which is MyCount:Count(CheckBoxName)
This will tell you the total number of Yes/True responses in CheckBoxName
If you know how to use SQL, you could write the code for a whole number of these check boxes; alternatively, write a query for each one .. but that will be a lot of queries so the SQL route will be better.
Next make another query2 based on the one above where there is only one field in the QBE grid which is MyCount:Count(CheckBoxName)
This will tell you the total number of Yes/True responses in CheckBoxName
If you know how to use SQL, you could write the code for a whole number of these check boxes; alternatively, write a query for each one .. but that will be a lot of queries so the SQL route will be better.
