Solved

MS Access 2010 Report

Posted on 2013-01-13
7
300 Views
Last Modified: 2013-01-14
Hi Guys
I trying to create a report on a regular 8.5x11" page
The Report header is 7.5" wide
page left and right margins are 0.5" each
The detail section has 2 x 3" columns and is 6" wide
I would like center the  detail section  horizontally without reducing the width of the report header.
Any help is appreciated
Thanks
Dory
0
Comment
Question by:dory550
  • 3
  • 2
  • 2
7 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 38771677
I think you may have to add your main 2-columns report as a subreport to a main report that contains the headings you want.  You can then size and place the subreport as you require.
0
 
LVL 30

Expert Comment

by:hnasr
ID: 38772095
What is stopping you from producing such a report?

Try creating the report, and upload. Explain where do you want help.
0
 

Author Comment

by:dory550
ID: 38772152
hnasr
Attached is a rough sample of the report (flyer) I am trying to create
I am trying to (horizontly) center the 2 columns on the page
Thanks
Dory
Rp-Flyer-6.pdf
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 30

Expert Comment

by:hnasr
ID: 38772451
We expect an Access database with the report.
You may solve it yourself by changing the margins.
0
 

Author Comment

by:dory550
ID: 38773600
hnasr
Attached is a database (2003)
it contains one table and one report
I am trying to horizontly center the 2 column in the report without changing the width of the report header
you may convert database to 2010 if needed
Any help is appreciated
Dory
Database1.mdb
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38773630
I have explained in the first response what you have to do.  I don't believe you will find any other solution.
0
 

Author Closing Comment

by:dory550
ID: 38776951
peter57r
Thank you for your help
Dory
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

920 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

15 Experts available now in Live!

Get 1:1 Help Now