Totals Query

[workingpoor]

I have a table that I want to sort by the by class year. But i have like 20 options that are yes/no that i want to count the total of each so that i can do charting in excel.

I have no idea how to create the query. I know that I only have to count the yes's.

Bascially I need to my query to show me something like this
Year AE ALD TUTOR FS
2006 3 5 8 1
2007 5 5 9 0

Year is a number
AE, ALD, Tutor, FS are boolean yes/no

i don't want the select to find what is true for all
just count each field individually but display it together.

Does that make sense?

I am really lost please help.

 

[FoFa]

Well true/yes/checked is -1 and of course false is 0.
So SUM(ABS([AE])) should do it for you as an example on your AE column.