Columnar Output in a Report

[silva]

I'm trying to create a report that displays a small amount of information
froma record. The query used generates a lot of records that match the
criteria, but due to the small amount of information actually required, the
data stretches on beyaond a page, all in a small single column with a large
quantity of blank space on the pages.

What I'd like to do is be able to have multiple records display both
horizontally and vertically (sorted by column or row is not important). For
example:

Record 1 Record 2 Record 3 Record 4 Record 5
Record 6 Record 7 Record 8 Record 9 Record 10

It's basically only one field per record I need to display. Is there any way
to do this without necessitating an entire line for each record?

 

[fredg]

I'm trying to create a report that displays a small amount of information
froma record. The query used generates a lot of records that match the
criteria, but due to the small amount of information actually required, the
data stretches on beyaond a page, all in a small single column with a large
quantity of blank space on the pages.

What I'd like to do is be able to have multiple records display both
horizontally and vertically (sorted by column or row is not important). For
example:

Record 1 Record 2 Record 3 Record 4 Record 5
Record 6 Record 7 Record 8 Record 9 Record 10

It's basically only one field per record I need to display. Is there any way
to do this without necessitating an entire line for each record?

In Report Design View (or click the SetUp tool button in Report
Preview) click on
File + Page SetUp + Columns

Enter the number of columns wanted.
If the report width is the width of one detail column, place a check
in the Same as Detail box.
If the report width is greater than one detail column, uncheck that
box and enter the wanted column width.

Then, in the Column Layout section, select Across then Down or Down
then Across.
See Access Help for more information.

 

[silva]

In Report Design View (or click the SetUp tool button in Report
Preview) click on
File + Page SetUp + Columns

Enter the number of columns wanted.
If the report width is the width of one detail column, place a check
in the Same as Detail box.
If the report width is greater than one detail column, uncheck that
box and enter the wanted column width.

Then, in the Column Layout section, select Across then Down or Down
then Across.
See Access Help for more information.

Excellent! This worked perfectly. I suppose if I paid a little more
attention to certain things, I would've seen this ability already. Anyway,
thank you.

 

[fredg]

On Wed, 19 Mar 2008 14:37:01 -0700, silva wrote:

*** snipped **

Excellent! This worked perfectly. I suppose if I paid a little more
attention to certain things, I would've seen this ability already. Anyway,
thank you.

But then guys like me would have to be out in the back yard pulling
weeds, instead of sitting with our feet up on a desk sipping a cup of
coffee. <g>