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?

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top