Creating a Report based on survey

[Moogie]

Creating a basic db for someone to use for a survey of 500 or so people. For each question, there will be 4 answer choices. Let's just say for now - A,B,C,D (text datatype)

User will be using a form with combo box / row source - table with the values. So they can just click and choose the appropriate answer.

On the report I want to be able to show each question with a total for each of the answer choices.

Ex.

Q1 A=12 B=3 C=2 D=0
Q2 A=12 B=3 C=2 D=3
Q3 A=11 B=2 C=1 D=4

[ADezii]

Creating a basic db for someone to use for a survey of 500 or so people. For each question, there will be 4 answer choices. Let's just say for now - A,B,C,D (text datatype)

User will be using a form with combo box / row source - table with the values. So they can just click and choose the appropriate answer.

On the report I want to be able to show each question with a total for each of the answer choices.

Ex.

Q1 A=12 B=3 C=2 D=0
Q2 A=12 B=3 C=2 D=3
Q3 A=11 B=2 C=1 D=4

1. Create 4 Unbound Text Boxes on your Report, with their Control Sources set to the following:
   = DCount("*", "tblSurvey", "[Reply] = 'A'")..........'for Reply A
   = DCount("*", "tblSurvey", "[Reply] = 'B'")..........'for Reply B
   = DCount("*", "tblSurvey", "[Reply] = 'C'")..........'for Reply C
   = DCount("*", "tblSurvey", "[Reply] = 'D'")..........'for Reply D
2. Be sure to substitute uoyr Table Name for tblSurvey, and your Field Name for Reply.