conversion of columns in row in MS Access (1 Viewer)

[manojbiswas]

I have a union query which is a rusult of 2-3 queries. This union query gives results like

ACTIVITY MONTH1 MONTH2 MONTH3 MONTH4 MONTH5 MONTH6 ... upto MONTH36

PLAN 1.5 2.1 3.1 1.0 1.2 4.6
ACTUAL 1.2 2.O 2.9 0.7 1.0 2.7

ACTIVITY, MONTH1, MONTH2 ETC is column of the query headings. and 1st row values are PLAN, 1.5, 2.1 etc and 2nd row values are ACTUAL, 1.2 2.0 etc.

I want to prepare a chart for monthwise progress for PLAN and ACTUAL values. For preparing the chart I need to realign the data in following manner. Ans so i need to write a query.

MONTH PLAN ACTUAL

MONTH1 1.5 1.2
MONTH2 2.1 2.0
MONTH3 3.1 2.9
MONTH4 1.0 0.7

etc.

Please help me to write a query for realigning the data as above.

Manoj Biswass

 

[DCrake]

As your first 2-3 queries make up your union query then are these tables horizontal or vertical?

Would be easier to post a sample subset of data to be more enlightning.

 

[manojbiswas]

As your first 2-3 queries make up your union query then are these tables horizontal or vertical?

Would be easier to post a sample subset of data to be more enlightning.

These table are horizontal.