Changing Columns to Rows

[Lynn63]

I inherited a database that is the back-end of a web based survey. My task is to help the survey analists extract the data. Their requirement is to have the data come out as one row per survey respondent. However, the developer designed the table to collect the data as follows: Each "answer" is given a unique "answerID" thus if there are 100 questions, survey respondent 1, for example, will show up in the table 100 times (once per answer). Is there a way I could build a query to get the data to come out 1 row per survey respondent. Everything I tried thus far has failed. Thanks in advance...

 

[Pat Hartman]

From your description, it sounds more like you are trying to turn row into columns. Try a crosstab query.