Repost Creating a comparative report

[Tony Williams]

Sorry to repost but I am struggling with this. I have a suggestion which
revolves around normalising data and producing union queries but am having a
struggle understanding that concept. Is there any other way?
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
Lbl txtdata1 txtdata1,
txtdata1,
Lbl txtdata2 txtdata2,
txtdata2,
Lbl txtdata3 txtdata3
txtdata3
etc etc
etc etc
So the data might look like this:

March 2003 March 2004
Industrial Advances 2345 5678
Personal Advances 46575 45758
Agricultural Advances 454747 64474
etc
etc

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

[Pieter Linden]

Tony,
looks like your database isn't normalized properly. Do you have
several tables with at least nearly identical structures? If so, your
data probably isn't normalized properly. From the looks of your
report, this should be a walk in the park. Just group/sort by some
field and you're on your way (well, assuming your data is normalized
right).

[Tony Williams]

Thanks Pieter but I'm a newbie what do you mean by normalise?
Tony
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...

Tony,
looks like your database isn't normalized properly. Do you have
several tables with at least nearly identical structures? If so, your
data probably isn't normalized properly. From the looks of your
report, this should be a walk in the park. Just group/sort by some
field and you're on your way (well, assuming your data is normalized
right).