Hi all,

I was wondering if this was possible to do at all using access or ideas on how to do it in any other way.

To do what appears to be a multiple set of reports with different formats, look into making a single report unbound (or lightly bound) to any table.

Create bound reports for each different part of your desired report. Divide and conquer!

In the unbound report, insert sub-reports that contain the individual detailed reports.

Now when you open the parent report, it opens and inserts the detailed reports as its children. I did something like this just a couple of weeks ago.

Thinking of the report as a monolithic beast - you cannot get where you wanted to go. BUT thinking of it as a divisible report - no big deal. Just because it is divisble doesn't mean you have to put borders or other visible elements around the divisions.

Hope that is clear enough.

You've lost me lol.
An example of this would be awesome, i know it might be too much to ask so its okay if you cant.
Ill look around though

Thanks

Sorry, cannot send examples from this military site and I'm having a p|$$ing match with my home ISP right now.

Create the report pieces you want with a report wizard. Treat them as two independent entities. (Or three if you have three such reports.) Treat each section of your image as a separate report as though it was NOT going to be a single report.

Now create an empty report NOT using a wizard. (Because you want to create an unbound report.)

On the empty report, create as many sub-form/sub-report controls as needed for your report fragments - with the controls wizard enabled. You won't have a parent-child relationship between the parent and the subs because the parent is just a place holder. So decline to define a linking field when the wizard asks for one. Specify the name of the fragmentary reports you created earlier.

HINT. When making these reports, make the parent and the fragments have the same exact width. On the sub-report control, bring up properties and set CanGrow = YES.

This is as clear as I can make it.