Query answers in different columns

[cb@chrisb.eu]

Hi
Gender Q: (e.g.) Male or Female?
How do I get (e.g.) Male answers in one query column, and (e.g.) Female answers (to the same question) in query column 2?
Repeating the question, and specifying the different answers, does not work.

 

[jdraw]

You design your database to do what you need.

Research Normalization
You may also get key info from
http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452

Good luck

 

[cb@chrisb.eu]

This seems somewhat wider than required. I'm familiar with normalization. this is about seperately listing answers to single questions, so if 3 answers are possible to one question, how do I get answer1s in column 1, 2s in column 2, etc? Or can I set up a countif function in subsequent columns?

 

[jdraw]

Countif tells me you are NOT working with Access.

How about 2 tables

tblQuestions
QuestionId PK
QuestionDesc



tblAnswers
AnswerId PK
AnswerDesc
QuestionID FK

Just an idea for consideration (untested).