Report In Access 2003. 2 duplicate A5 report in 1 A4 paper

Hi guys, I am doing a payment voucher system using access 2003.

I need to output the report in the following way.

Can anyone tell me how should i do it?

http://img34.imageshack.us/i/45852471.png/

Thanks
Regards
Alfred
moneywellAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I assume the two "parts" would have similar data (i.e. be pulled from the same Record)? If so, depending on what data you've got to show, and how it must be summed/averaged etc, you could either (a) do this with a single report (everything in the Detail section of one report) or (b) use Subreports. I'd suspect you'll need to use Subreports:

1) Build two subreports that represent each "section" of the overall report - i.e. one for the F&A copy, one for the External copy.
2) Build another report that will hold both of those subreports.

As to your "For Accountants Use" section ... that could be tough to get that to display correctly ... Access likes to fill things from the top down, and if you have no records "above" this, you'll have trouble forcing that to move "down" ...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
The stumbling block with these types of reports is that Access can have a tough time duplicating exactly a report similar to a paper Voucher (Invoice, Reciept, Bill, ...ect)
This will be the graphical "Design" of a report like this.

Sum issue can be:
Blocks that span many Detail records.
Can Grow/Shrink properties
Text Wrapping
"Padding" the report with Blank Records
Borders around sections

As any expert here will tell you, you can "Do" anything.
How much trouble you are willing to go through is another story.
;-)

So asking us "How should i do it?", is a bit vague and actually seems like you are asking us to walk you through the entire process.
Is the datebase already complete and fully functioning?
How familiar are you with Report design?

Perhaps you should start by asking a *specific* question about this.

;-)

JeffCoachman
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.