Creating a comparitive report

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

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
 
Sorry the final layout should be like this:

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

Thanks Tony Williams
 
Back
Top