Analyse results in any format

[C2680mor]

Hi all,

newish to Access so please forgive if this is really easy.

I have a database where people have answered questions to a survey. The returns are

Yes
No
Don't Know

I want to find a way of showing how many of each entries are in each question.

At the moment I am exporting to excell and using pivot tables, but I am sure there must be a way to do this inside Access.

All help appreciated.

Thanks,

Chris.

 

[neileg]

You could do a totals query based on the question and answer. Instead of using the default Sum calculation use the Count.

You could probably use a cross tab query to give yourself a table, but I don't use these myself.