Array problem?

[rcollman]

I want to convert answers from a survey to a different form. In Table1 my fields are SurveyID, Q1, Q2,Q3,Q4. I want to convert them to Table2 that has the fields SurveyID, Question#, Answer.

At one time I knew how to do this in DOS Paradox scripting language with an array, some loops and whiles. No clue in VB. Pointers would be appreciated.

Chris

 

[Alexandre]

Sorry I didn t completly get it.
You have

SurveyID...Q1....Q2...Q3...Q4
1.........Val1..Val2.Val3..Val4

And would like to get

SurveyID.....Q
1 ..........Val1
1...........Val2
1...........Val3
1...........Val4

Is it right?