Solved

how to create Column report Headers?

Posted on 1998-03-23
9
207 Views
Last Modified: 2009-12-16
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
Comment
Question by:altena
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 7

Expert Comment

by:spiridonov
ID: 1971516
Put three lables into report's page header -one for each column.
0
 
LVL 3

Expert Comment

by:guillems
ID: 1971517
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
 
LVL 3

Author Comment

by:altena
ID: 1971518
That (regrettably) does not work.

Here is what happens:

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

0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1971519
Which of two proposed solutions doesn't work?
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 3

Expert Comment

by:guillems
ID: 1971520
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
 
LVL 5

Accepted Solution

by:
cekman earned 50 total points
ID: 1971521
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
 
LVL 5

Expert Comment

by:cekman
ID: 1971522
You absolutely do NOT need to make 3 separate sub-reports - unless you're really doing something special.
0
 
LVL 3

Expert Comment

by:guillems
ID: 1971523
In this case, I'm agree with cekman.

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


0
 
LVL 3

Author Comment

by:altena
ID: 1971524
Thanks for pointing this out.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now