calculate sums in columns 1

[pduncan]

I have a query that queries a couple of tables to create 3 columns. It represents answers to questions (yes/no). The columns are 1.)Question Number 2.)Yes's 3.)No's
My question - I know how to count the total number of rows in the table, but how can I count individual Yes's or No's?
For example, I intend to use these as sub portions of a report that will eventually show something like this:


TOTAL YES NO
Ques 1 120 100 20
Ques 2 120 60 60
Ques 3 120 40 80
... etc

PDUNCAN - MEMPHIS, TN

"I'm living so far beyond my income that we may almost be said to be living apart."
- e e cummings

 

[pduncan]

Jim - thanks a bunch. That did it.

PDUNCAN - MEMPHIS, TN

When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.

 

[jdegeorge]

Glad to have helped, and thanks for the star!

Jim DeGeorge