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

You'll need to make thirty append queries - one for each question or write a VBA code loop that reads the poorly designed table (fire the person who built it) and writes 30 records into the new table for each record in the input table.

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