Conditional Counting

  • Thread starter Thread starter Tina S
  • Start date Start date
T

Tina S

I have a table that has survey answers in it.
The answers are either "Yes", "No", "DK" or "N/A".

Example: 10 survey
6 Yess
2 Nos
1 DK
1 N/A

I need to count the yess and then divide this result by the yess and nos.
Example: 6/8 = 0.75

I am a novice to Access so please tell me exactly where I need to put the
info you give me. Thanks.
 
Back
Top