how to create Column report Headers?

I almost have my access-report the way I want it:
3 columns of data, set using the print-settings

The report now looks like this:

Header
Data1   data5  Data10
data2   data6  data11
data3   data7  data12
...

How do I make the report look like this:
Header  Header Header
Data1   data5  Data10
data2   data6  data11
data3   data7  data12
...

Thanks in advance
LVL 3
altenaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Victor SpiridonovCommented:
Put three lables into report's page header -one for each column.
0
guillemsCommented:
Try to make three sub-reports in the main report, so for each column you can see the header, and you can change the header for each one.

I hope this help you!
0
altenaAuthor Commented:
That (regrettably) does not work.

Here is what happens:

Header  Header Header
Data1                 data5  Data10
data2                 data6  data11
data3                 data7  data12

0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Victor SpiridonovCommented:
Which of two proposed solutions doesn't work?
0
guillemsCommented:
Do you try to make a three subreports?

If you send me your database I'll make the report, with three subreports. My e-mail is guillems@i6.com

0
cekmanCommented:
There is an example of this in the SOLUTIONS database that comes with Access. Open Solutions choose CREATE ADVANCED REPORTS then select Create a Multi-Column Report.

Basically you redefine the column headings (repeat them to the right of the ones you've already created, and change the Page Setup options to handle the new width of the columns.

This is described in detail in the Solutions.mdb

Good Luck
CEkman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cekmanCommented:
You absolutely do NOT need to make 3 separate sub-reports - unless you're really doing something special.
0
guillemsCommented:
In this case, I'm agree with cekman.

SO I just put a comment, not an answer 8-)


0
altenaAuthor Commented:
Thanks for pointing this out.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.