How do I pivot specific information in queries? 1

[Mgoo]

Hi all,

Pre-thanks for reading this.

I am in the process of reporting data based on surveys that have been conducted.
I have a hand full of different tables (Survey, questions, answers, contacts, surveylink (Contacts & surveys to answers)). I would like to display the survey results on a report like the following:

Question Text Person A Person B Person C
1. How are you Good Great Had Better
today?
2. Did you eat Yes Yes Somewhat
today?
.... continues...


Currently I have the "Question Text" componet set up by making a query selected by survey.

I am having trouble with displaying the individuals information. It is stored in one table named "answers". From queries I can get only one get individuals answers and display it by a sub-form.

I was hoping if someone knows a way to display the answers similar to what I mentioned above by making it in a query.

I read that there are ways to do this in a temporary-table but that would be poor methods (it does get the job done but not nicely).

Thank you
Mgoo

 

[Mgoo]

I think this is transposing in access.

 

[PHV]

I'd follow the CrossTab query wizard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Mgoo]

The total row cannot be toggled off in a crosstab query. I am not looking for the total row and have no use in it. I know that I can use Union to add a query to a query vertically and am looking for something like this but horizontally.

Current Data:
Person A Yes
Person A NO
Person B No
person B Maybe

I want:
Person A Person B
Yes No
No Maybe

 

[dhookom]

The At Your Survey application has an interface for creating crosstabs on the fly.

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

The data you provided is incomplete and can't be presented as you want without a field that identifies a question number or similar.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Mgoo]

perfect, the program you directed me to has shown me how i incorrectly arranged my data and I can now pull the information I need. Thank you.