Creating a comparitive report

[Tony Williams]

I have a report based on a query. I have a field called txtmonthlabel and a
number of fields that hold numeric data eg txtdata1, txtdata2,txtdata3 etc
etc. The query finds my data but displays it on the report as:
txtmonthlabel 1
txtdata1, txtdata2,txtdat3 etc etc
txtmonthlabel 2
txtdata1, txtdata2,txtdat3 etc etc

What I want is:
txtmonthlabel 1 txtmonthlabel 2
txtdata1, txtdata1,
txtdata2, txtdata2,
txtdata3 txtdata3
etc etc
etc etc


So the data might look like this:

March 2003 March 2004
2345 5678
46575 45758
454747 64474

I have tried using the column function but that doesn't seem to work. Can
someone help?
TEA
Tony Williams

 

[Tony Williams]

Sorry the final layout should be like this:

March 2003 March 2004
Data1 2345 5678
Data2 46575 45758
Data3 454747 64474

Thanks Tony Williams