Multiple selects on same table

[Diadeloza]

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.

I am fairly new to Access, any help will be appreciated!
Thanks in advance!

 

[ania12]

I dont understand your problem.
(e-mail address removed)

 

[Diadeloza]

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