Check Boxes and Queries

B

Belinda

In a tabel I have created check boxes (tick for yes, leave blank for no) and am trying to calculate in a query how many yes's I have and how many no's. How can I do this???? Please help????
 
M

M.L. Sco Scofield

You need to use a "totals" query.

Click on the funny "E" (Says "Total" when you hover over it.) on the toolbar
to turn on the totals row.

Bring your field down to the grid twice. Leave the first one set to
"GroupBy." Change the second one to "Count."

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Belinda said:
In a tabel I have created check boxes (tick for yes, leave blank for no)
Click to expand...
and am trying to calculate in a query how many yes's I have and how many
no's. How can I do this???? Please help????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mark-as-read problem 0
Populate a table based on check box status 2
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Wrapping and Anchors 0
Query: how to count up data from different fields 3
Creating a checklist with predefined comments 1
Word OLE to check spelling in text box 1
Problems created by Recent updates to Outlook 365 0

Top