Two recordsets on one report..

  • Thread starter Thread starter Warrio
  • Start date Start date
W

Warrio

Hello!
Is it possible to have a report that displays 2 lists of records? the
perfect result would be a report that contains a sub-report.

and I cannot put a query that selects both of the tables otherwise, I'll
have multiplication of result

Thanks for any suggestion!
 
It sounds like what you want IS a sub-report. Just like a sub-form, you can
create sub-reports. In this case, the main report would have as its
datasource one of the tables, and the sub-report would have the other table
as its datasource. If there is no relationship between them (parent-child),
then you simply don't put any parent-child link in the sub-report
properties.
 
Back
Top