?
Solved

MS Access 2010 Report

Posted on 2013-01-13
7
Medium Priority
?
313 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 2000 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 31

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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 31

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

862 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