include subquery in report?

A

Alex Pavluck

I am using a query in access and then using a subquery to add a '+' at
the beginning of each row to display additional information. How do I
add the subquery information to a report?
 
J

John Vinson

I am using a query in access and then using a subquery to add a '+' at
the beginning of each row to display additional information. How do I
add the subquery information to a report?
Click to expand...

Do you mean a Subquery - or a Subdatasheet? I'm guessing the latter!

Rather than trying to use the (very limited) datasheet capabilities in
your Report, consider basing the Report on a Query joining your two
tables. Use the Report's Sorting and Grouping dialog to group by the
main table's information; put fields from the main table in the
section header for that table, and the detail records from the second
table in the Detail section of the report.

John W. Vinson[MVP]
 
Top