Check Boxes and Queries

[Guest]

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.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

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????