Multiple selects on same table

D

Diadeloza

Joined
Dec 27, 2011
Messages
2
Reaction score
0
Hello there!
I was given an Access database with one table that has 70 combo boxes that contain Yes, No or N/A. I need to count the number of Yes, No or N/A. So far I have only been able to count the records in the first combo box by using

SELECT Count(*) as Total
FROM mytable
GROUP BY location

I hope this can be done. :confused:

I am fairly new to Access, any help will be appreciated!
Thanks in advance!
 
I need to count the number of "yes", "no" and "n/a" in every single field, my table has 70 text fields. I need a report that lists the Field name and the number of yes, no or n/a
 
Last edited:
Back
Top