columns in a report

[mostly harmless]

Hi, Im trying to make a report that will spread the results of a query
over two columns. I thought that one way of doing it would be if I
could make one query that would put the first ten results in one
column and visa versa for the second column.

I havent figured out how I can refer to the record number in a query.
Could someone tell me how? of if there is a better way of doing this.

Thanks

Jonathan

 

[fredg]

Hi, Im trying to make a report that will spread the results of a query
over two columns. I thought that one way of doing it would be if I
could make one query that would put the first ten results in one
column and visa versa for the second column.

I havent figured out how I can refer to the record number in a query.
Could someone tell me how? of if there is a better way of doing this.

Thanks

Jonathan

Jonathon,
Is there any reason you can't use just one query and the Report's
columns setup to print the report with several columns instead of one.
In Report design view:
File + Page SetUp + Columns

Set the column count to 2 (or more) and the other settings on that page
as needed.
Make sure you indicate either 'Down then Across' or 'Across then Down'.