Swap Fields and Rows

cable

Access For My Sins
Local time
Today, 09:55
Joined
Mar 11, 2002
Messages
226
I have the following:

Month Tot Mat Acc
2004Jan £246,000,000.00 £2,698,000,000.00 £1,144,570.91
2004Feb £262,000,000.00 £22,000,000.00 £1,133,320.02
2004Mar £237,000,000.00 £43,000,000.00 £1,114,454.21

And need to swap the fields and the rows around, to get
Jan04 Feb04
JanTot FebTot
JanMat FebMat
JanAcc FebAcc

I think i need a union query but not sure how?
 

Users who are viewing this thread

Back
Top Bottom