Column output

D

Don Parker

I want to have a report that will take one column and fill up a page with the
contents. In other words, I have a report that gets one column of data from
about 100 records. The particular field is "last name." When the report
generates, the print preview shows 4 pages and on each page is a single
column of text. I want the data to fill up a printable sheet. How can I do
this?

The output looks like this:

LN
person1
person2
person3
person4
<page break>
person5
....
<page break>
....
person100

I want it to look like this:

LN
Person1 Person5 Person9
Person2 Person6 and so on...
Person3 Person7
Person4 Person8
<page break>
LN
Person50 Person54
Person51 Person55
Person52 and so on....
Person52

So, you see, I want to fill up a page for printing and not have a whole
bunch of pages with only a single column of text on them. The data comes
from the same column in my Access database
 
J

Jeff Boyce

Don

Have you checked the File | Page Setup menu choice from within the report
design window? You should be able to set columns there.
 

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