You must be able to join all the queries; a field from each query joined to
a related field in one of the other queries. If you can't do that, you can't
create a report from the queries. If you can't do that, either you did not
include needed fields from the tables that your queries are based on or your
tables are not designed correctly.
Not totally true. The queries may need to be used as the Record Source of
the subreport. For instance a report of employees may have a subreport of
Position History and a subreport of Certifications. The Position History is
not related directly to Certifications. They are both related to an employee
and can be represented on a main "employee" report as subreports.
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.
