Crosstab query?

[thart21]

I am trying to think of a way to avoid doing this manually, but I don't think I can. We have a survey that was created by an outside person in Access. All I have access to is the table that the survey created and it is in this format for 30 questions:

Col 1 Col 2 Col 3 Col 4
Q001 Comment001 Q002 Comment002

What I need to end up with is a new table with these columns like this:

JobID QuestionNumber AnswerNumber Comment
(this is Q001)

Any ideas would be appreciated!

Thanks,

Toni

 

[thart21]

Thanks so much Pat! The append query(s) worked great-you saved me from having to manually input 1584 records(again). I though the format of the db was a little weird when I saw it, but I'm still new and wasn't sure. And yes, I am trying to push this consultant out so I can take over!

Thanks again!

Toni