2 Columns in a Subreport

[Karissa]

I have my subreport set up as 2 columns. The page is 7.5" wide, each column
is 3.75" wide, and there's no space between the columns.

I have my main report set up as 1 column. The page is 7.5" wide.

When I run the main report, the subreport gives me 1 column. I have tried
making the subreport page & columns smaller, but that doesn't help. The
subreport is in the Report Header. I tried putting it in the Page Header,
but it only gave me the first record.

How can I make my subreport be two columns while my main report is one column?

Oh, and in case it matters, I'm using Access 97...

 

[Duane Hookom]

Make sure the columns are set to display across then down.

 

[Karissa]

That worked great, thanks!

I guess there's no way to do it as down then across?

 

[Duane Hookom]

You can create a calculated column in your reports record source such that
when it is printed across then down, it looks like it is down then across.
For instance if you want two columns and have 30 records you would create a
column that numbers the records
1
16
2
17
3
18
....

Duane Hookom
MS Access MVP