Query to transpose Data in Columns to Rows

[ace1259]

Hi all,

I'm looking to make a pie chart in an Access report and this can only be down when the data is in a single row. I have a query that gives me the following:



Store1 Store2
500 1,000

and need a table or query so the data reflects:

Store Sales
Store1 500
Store2 1,000

Any suggestions would be appreciated!

[June7]

What is the source table data structure? Is it the same as the query example? How many stores are there?

Requires a UNION query. There is no query designer or wizard for UNION, must type into the SQL view editor of query designer. There is a limit of 50 lines in a UNION. The UNION query essentially rearranges the data into a normalized structure.

SELECT ALL "Store1" As Store, Store1 As Sales FROM tablename
UNION SELECT ALL "Store2", Store2 FROM tablename;

[ace1259]

Worked Great! Thanks much, I tried for the longest time to get the Union query to work on this and couldn't get it to work. Thanks!!!