Table with Subdatasheets reflected in a Report

[Alcide]

Hello All,

Got a table with a connecting subdatasheet looking beautiful. However, I need the "same" thing in a Report. I can give a description of the table, if necessary. However, got a hunch that there is a simple way to create a Report from that Table that includes the subdatasheet as a subreport without having to go through the subreport wizard in Report Design View.

The Question: How to get a Table with associated subdatasheet reflected in a report.

Thanks for the help!!

 

[Allen Browne]

1. Create a query using the main table, and also the table from the
subdatasheet.

2. In query design view, double-click the line joining the 2 queries.
Access offers 3 options. Choose the one that says:
All records from MyMainTable, and any matches from
MySubdatasheetTable.

3. Save the query.

4. Use the query as the source for the report. Group on the main table's
primary key, so the main table's fields are shown once only (in the group
header), and the related table's fields are shown in the Detail section of
the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Got a table with a connecting subdatasheet looking beautiful. However, I

need the "same" thing in a Report. I can give a description of the table, if
necessary. However, got a hunch that there is a simple way to create a
Report from that Table that includes the subdatasheet as a subreport without
having to go through the subreport wizard in Report Design View.