By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,071 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

How to "crosstab" when I'm not appropriately relational?

P: n/a
Hi All,

I have a question I didn't even know how to search..

I have a survey database I've inherited. The main table is as
follows:
ResponseID
SurveyID
LocationID
Q1
Q2
Q3
Q4
....

It's great for reporting straight survey results. But, now I'd like
to replicate some Excel analysis the previous guy did. He's got the
following output:

Average analysis
Question / Loc1Avg / Loc2Avg / Loc3Avg / etc / TotalAvg
Q1 / x.x / x.x / x.x / x.x / x.x
Q2 / x.x / x.x / x.x / x.x / x.x
Q3 / x.x / x.x / x.x / x.x / x.x
Q4 / x.x / x.x / x.x / x.x / x.x
Avg / x.x / x.x / x.x / x.x / x.x

I would like to "crosstab" this, but the table structure won't allow
it.

I've written the query to get the data, but it's obviously swapped/
transcribed on the x/y. Any ideas for flipping without me writing the
mother of all union queries? Pivot tables maybe?

TIA,

Jon
Aug 11 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.