Converting Tables

[dancing_Noodles]

Hi I'm new to MS Access so please be gental. My Question is this
I have a table with multiple questions set up as columns the columns contain answers to the questions.....

ie:

customerid Quest 1 Quest 2 Quest 3

1001 50 75 100

And i would like to have the questions columns listed like this


customer id Question id Question Answer

1001 10011 1 50
1001 10012 2 75
1001 10013 3 100

Could you please offer any suggestions

the reason that im doing this is i need to be able to report on averages for each customers response for each question....

Thanks

 

[MikeAngelastro]

Hi,

Your second table will work just fine. You will be adle, using the aggregate functions, to get the average for each customer or for each question.

Mike