Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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
 
Back
Top