sub report question, multicolumns to span pages?

R

rex_deckard

I have formatted an Access report to be used for Bill of Lading
generation (BOL.)


For each shipment that is shipped, a BOL is generated. The contents of
the BOL are the BOL#, the Order#, & the Item Detail based on the
Inventory Transaction that was done against the Order#.

So the report contains Header information (where it is being shipped,
etc.)

Detail Info (the different Lots & Qty of Lot, these are equal to
individual pallets) This is the subreport

Footer info, such as misc. notes for the driver, signature blocks, etc.

The problem that I have run into is that the detail can sometimes have
as many as 52 records. I have this running across & then down in the
subreport, but to fit that on one page uses a very small font.

I would like the subreport to force a new page when it reaches 26
records, thus 2 across 13 down.

Any ideas on how to do this, or should I smack myself for missing it.
It occurred to me while writing this that I could add a column in my
query to count records so that when it hits "27" I could force a new
page or something like that, is that on track?

Thanks in advance.
 
Top