Add Query to Report

[Access dummy]

I have created a report from one table. After working with the report, I have found that I need to add information from several different queries. When I added the link to the report, it returns #Error.

Please help!!

 

[Pat Hartman]

You have three options:

1. Use subreports to show the data from the additional queries.
2. If the data is related on an appropriate foreign key, join all the queries and use the new query as the report's recordsource.
3. Use DLookup() to obtain the data from the additional queries.