Printing a report 2-up

B

Bill

How do I go about creating a report that retrieves data from my table and
produces a report of that data 2-up (side by side). ! record on the left and
the next record on the right?
 
S

Steve

You can do it with a snaking columns report that goes across then down.

Steve
(e-mail address removed)
 
B

Bill

How do I do that? For instance I have fields Name, Check, Amount, Paid by.
Whne I add these fields to my report they automatically go horizontality.
What do I do to make the 2nd record "snake"? etc.
 
J

John Spencer

Open your report in design view
In Access 2003 and earlier
SELECT File: Page Setup from the menu
Click on the Columns tab
Change Number of Columns to 2
Change Column Size Width to a value that is half the width minus your margins
and column spacing.
Change Column layout to Across then Down

You can do a similar thing in Access 2007 and 2010. You will just have to
find how to get into Page Setup when using the Ribbon.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top