Hi all,

I am converting an ORACLE app to Access. Moving
the data and doing the forms is not going to be
my main problem.

The app is a Software Problem Tracking system.
The report will contain data from many different
tables, but two of them contain Long (memo)
fields. The problem description may span several
pages and the corrective action may also.

Additionally, there are many sub-reports that
show the status history, software configs fixed,
and so on.

How to do this in a report?


+--------------------------------------+
| Name Page 1/n |
| Title |
| Status |
+--------------------------------------+
| Description |
| |
| |
| |
| |
| |
| |
| |
+--------------------------------------+

+--------------------------------------+
| Name Page 2/n |
| Title |
| Status |
+--------------------------------------+
| Description (cont) |
| |
| |
| |
| |
| |
| |
| |
+--------------------------------------+

.
.
.
+--------------------------------------+
| Name Page 3/n |
| Title |
| Status |
+--------------------------------------+
| Corrective Action |
| |
| |
| |
| |
| |
| |
| |
+--------------------------------------+


I'm guessing that this is going to entail
using a bunch of sub-reports. Anyone
have any thoughts or examples.

Thanks,
Wayne