Columns

A

Andrew T

I need to print a report showing the students that are going on a field trip.
I have the query worked out but the names only print in one column. I do not
know how to make a report do multiple columns. I also do not have the
Northwind data base loaded on this computer. The query had to have 3
conditions; under or over 18, still enrolled in school and parent permission
slip signed.
Thanks for the help. This was dropped on me this afternoon by my principal.
 
T

tina

try using the Label Wizard in the New Report dialog box. you can get columns
up/down, or across, that way. if you want a nicely centered header and/or
footer on your report, create a second report and put the "label" report in
the second report's Detail section, sized to suit. then put your
header/footer controls in the second report.

hth
 
A

Andrew T

tina,
That worked but it placed the names in order across the page not down the
page and then down the next column. I need them in alpha order from top to
bottom and then the next column. The wizard does work though.
Thanks for the idea, I am hoping this is an easy fix.
 
T

tina

open the subreport (label report) in design view. on the menu bar, click
File | Setup | Columns tab. change the Column Layout setting to Down, Then
Across.

hth
 
Top