multi query report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kennyademolu@hotmail.com(donotspam) - 21 Oct 2004 20:41 GMT

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?

Reply to this Message

Duane Hookom - 21 Oct 2004 22:00 GMT

"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.

Signature

Duane Hookom
MS Access MVP
--

> 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
[quoted text clipped - 4 lines]
> 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?

Reply to this Message