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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top