How do i creating a report from multipe queries (more than 5 quer.

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Back
Top