Yes/No and survey design

[Stephen Glynn]

I shortly have to tabulate the results of a survey that contains a
number of Yes/No questions. The answers to these, I assume, will be
best represented by Yes/No fields in my table of responses

Can someone please advise on how to write, or where to look for advice
on how to write, separate queries that will i) give me one row
containing the total number of 'yes' responses to each question; ii) one
that'll give me the totals for people answering 'yes' to (e.g.) Q1 and
Q3 and Q5 (i.e. 'yes' to all three, regardless of what they've replied
to the other ones); and iii) those who answer 'yes' to all those three
and only those three?

I've played round with various permutations and I'm getting myself
thoroughly confused.

Steve

 

[Douglas J. Steele]

Sounds as though you've got a row of Yes/No fields, with field names like
Q1, Q2, Q3.

That's not a good approach.

For a well-designed survey database, take a look at Duane Hookom's "At Your
Survey"
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 97'
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'