Hello group,
I need help on the following. I have a table with 8 different columns
all of them are checkbox options (e.g. yes or no).  I need to run a
report which sums the yes and no.

So it would look something like:

JOB TITLE
Yes XXXX number
No  XXXX number

JOB TITLE 2
Yes XXXX number
No  XXXX number

JOB TITLE 3
Yes XXXX number
No  XXXX number

So far, I create a crosstab qry but can only do one field at a time

TRANSFORM Count(CF.[JOB TITLE]) AS [CountOfJOB TITLE]
SELECT CF.[JOB TITLE]
FROM CF
GROUP BY CF.[JOB TITLE]
PIVOT CF.[JOB TITLE];

How can I create a qry that takes all of the fields into
consideration, so I can make a report off of it.

Thanks