• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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