How do I count multiple choice question letter answers?

[bmax]

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

 

[Duane Hookom]

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/OtherLibraries.asp#Hookom,Duane