I've inherited a survey 40 questions, most multiple choice letter answers and
an additional 10 fill in/comment questions.

I can't change. The data includes several past years which are being
updated and will contain new year data.

We need to count responses to questions. Possible answers are a-I
inclusive. I need to know how many of each response there are for each
question, move the count to a spreadsheet, calculate % and drive pie charts.

So far I've tried various count queries which only get me count of "a"
answers. The group that developed the database simply ran a query, resorted
each colmn and manually counted "a's", "b's", "c's", etc.

t/y

bmax

I would normalize this into either a table or query (union query) and then
use functionality like found in "At Your Survey"
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane

--
Duane Hookom
MS Access MVP
--

"bmax" <(E-Mail Removed)> wrote in message
news7D71D55-91AB-46B7-9806-(E-Mail Removed)...
> I've inherited a survey 40 questions, most multiple choice letter answers
> and
> an additional 10 fill in/comment questions.
>
> I can't change. The data includes several past years which are being
> updated and will contain new year data.
>
> We need to count responses to questions. Possible answers are a-I
> inclusive. I need to know how many of each response there are for each
> question, move the count to a spreadsheet, calculate % and drive pie
> charts.
>
> So far I've tried various count queries which only get me count of "a"
> answers. The group that developed the database simply ran a query,
> resorted
> each colmn and manually counted "a's", "b's", "c's", etc.
>
> t/y
>
> bmax