analysis of data

[C2680mor]

I have an access database containing the results of a survey.

Please forgive if this is very simple, I have not used Access much.

I need to be able to calculate the numbers of each answer and present the results as a table.

i.e question 1 is have your sales a, increased, b, remained constant or c, decreased.

I need a report, or data page to "count" the numbers of each answer.

At the moment I am exporting to excell and using pivot tables, but this is time consuming.

Thanks for the help,

Chris.

 

[ScottGem]

Have you tried a crosstab query in Access?