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?
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?