Generating a report based on a query

  • Thread starter Thread starter Thelonious Monk
  • Start date Start date
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!
 
You should be able to create multiple column reports. Selet File->Page
Setup->Columns.
 
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.
 
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.
 
Back
Top