Pivot Table : Two Values in a single cell

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Pivot Table : Two Values in a single cell

Author

Topic

David Schurmann
Starting Member

3 Posts

Posted - 2008-09-09 : 20:13:31

Hey Peoples,

Hope this makes sense my apologies if it does not.

This is the statement I am using to create the table. The only catch is that there are two values in this case ID's that need to be seen in the pivot table.

TRANSFORM First(Issues.ID) AS SumOfID
SELECT Issues.Impact
FROM Issues
GROUP BY Issues.Impact
PIVOT Issues.Probability;

What I would like to see is some thing like this

impact 1 2 3 4

a 1,2
b 3 5
c
d 4

abcd represent the impact and 1234 = probability.

Any ideas?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources