multi query report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi, i designed a report that is supposed to show the values of three
different queries in form of tables on the report,i achieved this by dragging
the queries onto the report in design view. problem is that now when i run
the report it generates a report page for every single row in all three
tables of the report.i test run it by entering about fifty values into the
main form and when i run it i got over fifty pages of reports.when all i
wanted could have taken a page or two.can anyone help me?
 
"dragging the queries"? You should be setting the Record Source properties
of reports and subreports to a single query, sql statement, or table. The
Northwind mdb has a report "Catalog" that uses a subreport that has its Link
Master/Child properties to limit record display.
 
Back
Top