Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

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
0
altena
Asked:
altena
  • 3
  • 2
  • 2
  • +1
1 Solution
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now