Print reports

[Pastor Del]

How can I set up a report to print 2 reports per page, i.e. report for first
record is printed on the top half of the page, report for second record
prints on the bottom half, third on top & forth on bottom, etc. The format
for each report is the same.

 

[Larry Linson]

How can I set up a report to print 2 reports per page,
i.e. report for first record is printed on the top half of
the page, report for second record prints on the bottom
half, third on top & forth on bottom, etc. The format
for each report is the same.

Doesn't seem like you'd need two reports, just one report printing multiple
records, each sized to occupy half the printable area. If you have
identical data about different "instances of the same thing, e.g., people or
organizations or automobiles or ..." in multiple tables, then you have a
database design issue, not a "how do I report this issue".

Perhaps you would clarify, in simple, straight-forward language, what kind
of data you have, how you have it structured in your database, and what you
are trying to accomplish. If we understand those aspects, we will be in a
much better positio to help you.

Larry Linson
Microsoft Office Access MVP

 

[Pastor Del]

To put it very simply, I need to print 2 documents per sheet of paper. These
sheets are cut in two and used seperately. The info does change from
document to document. I think you have stated just what I need to do, i.e.
use "one report printing multiple records, each sized to occupy half the
printable area." How do I do this?

 

[Larry Linson]

Assuming your data is arranged in records... and each record is what needs
to control what is a record... that is the way Reports work, out of the box.
You size the Detail Section of the Report in Design View -- be sure that the
Section does not have its Can Grow nor Can Shrink properties set to Yes.
The Report can be based on a Query, so additional Tables can be Joined to
the one that determines what is a Record.

If you are not aware of what a Report is and how it is created, and of
storing data in Records, in Tables, then perhaps you need to obtain and use
some self-study materials. "Microsoft Access <access version number> Step
by Step" is a good introduction for the complete novice; a much more
comprehensive book is "Microsoft Access <accessversionnumber> Inside Out"
both published by Microsoft Press. Links to various MVP's websites are shown
at http://sp.ntpcug.org/accesssig/ -- the one of particular interest would
be MVP Crystal Long's videos on YouTube. There is also online training
material at the Microsoft Office Online site... accessible via Help in
Access 2003 and Access 2007, or directly as http://office.microsoft.com.

In your terminology, I don't know what you mean by "document" when you say
"2 documents per sheet".

Are you working with information so confidential that you can't describe
what kind it is, without revealing the specific content? Something like
"each record represents an organization, and has fields containing the name,
address, subject, and a link to another table for the contact person" -- it
wouldn't make any difference to me whether the organizations were gangs,
clubs, businesses, churches, or sports teams.

Because a Report only displays data from Table(s) and/or Query(Queries), no
one can tell you how to do it unless they know what your data is and how you
have structured the way it is stored. I could guess, and offer analogies,
but frankly I'm donating my time as a volunteer and I don't have the
motivation to waste time extracting information like pulling teeth to be
able to help nor trying to write a general basic training course in
newsgroup articles.

Larry Linson
Microsoft Office Access MVP