May 29 2005, 01:51 PM
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.
May 29 2005, 01:55 PM
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 ...
May 29 2005, 09:36 PM
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.
May 29 2005, 09:43 PM
I have never been able to get child records this way ...
Maybe your Access works different than mine ...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here