count multiple fields in one query

[jedder18]

have a query with test results in field 1, set up count for field 1 to give me field1....group by.....field1....count of those with criteria of 0...
Have 12 fields in this query that need the same setup..
Is it possible to count 12 fields in 1 query?
It works for 1 field, but, when the others are in query, gives me all 0
Do I need to run separate count query for each field then combine results into 1 query?

using Access 2007....windows 7


Jen

 

[MarkK]

Count() counts records, not fields.
Mark

 

[jedder18]

The field contains the records....

I ended up using the sum function

The field contained a 1 or 0

I did want to count the 0's...
instead summed and got the count of 1's so figured the % of 0's from that count and the overall count.

Got the results needed this way....

 

[MarkK]

Nope, the record contains the fields.

Glad you got it figured out.