Horizontal to Vertival

[snoopy2003]

Hello,



I have a table with the following filed:

Product Family = A
Year = 2010
Q1 = 10
Q2 = 20
Q3 = 30
Q3 = 40

I wish to write a query which returns values in rows:

Q1 - Sum Q1 Values
Q2
Q3
Q4


Instead of : Q1 Q2 Q3 Q4

How can I do it ?

Thank you for your help

[ssanfu]

The first thing I would do is normalize your table structure. Right now, you are "committing spreadsheet". The following is the way I would design the table:

Field Names
-----------------
ProductFamily
P_Year
Amount
P_Quarter (Q1,Q2,Q3 or Q4)

Using this structure, it would be easy to construct a query to get the results you want.


Also, "Year" is a reserved word (and a function) in Access and shouldn't be used as object names. Here is a list of reserved word in Access:

http://allenbrowne.com/AppIssueBadWord.html