Hard Report Challenge 2 reports on one page

[Guest]

I have to create a report that show children added each month on top and
children dropped each month on bottom. I did this by grouping on status:
works fine. however I need the page to display 10 rows for added and 10 rows
for dropped. Did this with Duane Hookums help. Problem if there are more
than 10 records for either added or dropped I need to a new page identical to
the first with 10 rows for added at top with or with data and 10 rows at
bottom for dropped with or without data. Example if I have 14 dropped I need
a new page with 10 blank rows at top and 10 rows at bottom filled with 4
records.

 

[Larry Linson]

I have to create a report that show children
added each month on top and children dropped
each month on bottom. I did this by grouping
on status: works fine. however I need the page
to display 10 rows for added and 10 rows
for dropped. Did this with Duane Hookums help.
Problem if there are more than 10 records for
either added or dropped I need to a new page
identical to the first with 10 rows for added at
top with or with data and 10 rows at bottom
for dropped with or without data. Example if
I have 14 dropped I need a new page with 10
blank rows at top and 10 rows at bottom filled
with 4 records.

Sounds as if somebody thinks that the old forms done on a manual typewriter
were divinely inspired. It's been a few years since I encountered anybody
quite that stodgy, who wouldn't listen when I pointed out that there was
nothing sacred about the old way.

I'm sure what you want could be done, with enough time and effort, but it
would be better to do it in a logical way.

Have you asked _why_ it is _necessary_ that there be 10/10?

Larry Linson
Microsoft Access MVP