there are 3 options Yes Somewhat and Not really I want to count the records that only have Yes. going crazy can you help
there are 3 options Yes Somewhat and Not really I want to count the records that only have Yes. going crazy can you help
Make a query. This counts the items. Report on this query.
I forgot to inform you that it is a survey with 2 questions that have the same selection so if I put yes criteria in the question1answer then I will not get all the question2answer of yes
What do you mean they have the same selection? Why won't you get all the question2 records records with Yes answer? What is the table structure?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
As I suspected, not a normalized structure. The criteria would have to be applied to both question Answer fields using OR operator.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.