Generating a report based on a query

T

Thelonious Monk

I don't know if this is possible, but I will ask anyway:

I want to write a report that will be based on a query. The maximum number
of records that can be returned from the query is 90. However, instead of
printing each record one line after another, I would like to print three
columns of 30 records each on just one page.

Is this possible and, if so, how can it be accomplished?

Thanks!
 
D

Duane Hookom

You should be able to create multiple column reports. Selet File->Page
Setup->Columns.
 
M

Marshall Barton

Thelonious said:
I want to write a report that will be based on a query. The maximum number
of records that can be returned from the query is 90. However, instead of
printing each record one line after another, I would like to print three
columns of 30 records each on just one page.
Click to expand...


With the reprot open in design view, use the File - Page
Setup - Columns memu item to specify how you want your
columns arranged.
 
T

Thelonious Monk

Mr. Hookom and Mr. Barton:

Thanks! It worked like a charm. The only thing that I didn't like about it
was that the only way to get it to print was to change the print direction
to "across, then down". I would have preferred to have it print "down, then
up," but since I am using a sub-report, it does not look possible.

Thanks again for your help.
 
Top