Hi All

I have a database which is quite large, in terms of the number of tables it has. If possible, i want to produce a report which will shows fields from various tables, but on just one page.

Many thanks

Phil

Not much to go on here ....

You can create a query that combines the tables to create a recordset for the report ...
But .. if there are child tables involved .. you will need subreports to display these records ...

RDH

You can have many tables in a query.
Use a query to combine all the fields you need for the tables that are related into a single record for the report.

I have never been able to get child records this way ...
Maybe your Access works different than mine ...

RDH