Lettering mutiple choice?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

How do I letter mutiple choice answers on a report? I
have my questions #. I want my report to look like this.
But if a question only has 4 choices then on the report
not put in the letter E.

1.Question:
A. (answer 1)
B. (answer 2)
C. (answer 3)
D. (answer 4)
E. (answer 5)

2.Question:
A. (answer 1)
B. (answer 2)
C. (answer 3)
D. (answer 4)

Thanks for your help,
Rick
 
Do you have these questions and answers in tables and fields? If so, please
share your structure and possibly a sample of your records. You did a nice
job of stating how you want your report displayed.
 
I do have them set up in a table. Questions are a field
and each mutiple choice answer is a seperate field such
as, AnswerA, AnswerB, AnswerC, AnswerD, AnswerE. Also
used check boxes (yes/no) for each answer to pick correct
answer. Hope this makes sense.
My report is based on a Querie and selects random
questions to put into report. I was able to get the #
before the questions to work correctly but can't seem to
figure out how to do the mutiple choice answers to be in
a format A, B, C, D, E


Again Thanks Rick,
 
Do you actually have separate fields for each possible answer rather than a
single field for the answer to a single question? That is why I asked you to
share "a sample of your records". I don't ask just to make work for you.
 
Back
Top