Count certain fields in a record on what they contain - Access 2003
Posted on 2008-06-11
I have an Access 2003 db and I want to create a report or form that does the following.
Reach record has about 15.
Field1, field2, field3 etc.
Field1 is Name
FIeld2 is a question with a reposne of Yes, No
Field3 is an other quesitons with a resonse option of yes or no
I want to be able to sumaries each record as to how many yes answers there are and how many no answers there are.
I tried somethign like this but it did not work - it gave me the amount of reocrds in the the table.
SELECT Table2.Answer, Count(Table2.Answer) AS [Count]
GROUP BY Table2.Answer;