Field Names to Variables

D

Dave

I am collecting answers to questions using Option Buttons. Is it possible
in a query to capture a field name and make it a variable?

Example

Q1 for the field name can have a 1, 2, 3 or 4 as a possible variable answer.
I have over a 1000 answers to 12 questions. A crosstab is the hot ticket to
give me my results.

So what I want to know if I can create another field called Question that
uses the Q1 field name as the variable.

That way rather than having:

Field Q1 Q2
Variable 1 4

I would have

Field Question Result
Variable Q1 1
Variable Q2 4

and the crosstab would be easy.

Thanks
 
Top