Set Record Source to two queries?

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

Guest

Using Office 2003 and Windows XP;

I have a report whose Record Source is set to a query;

Question: Is there a way to make it point to two queries?

If not, how can I reference or return some results from a second query in my
report? The results will be many rows grouped a certain way...

Thanks much for your help.
 
The RecordSource of the Report can hold more then one Query/Table, as long
that you can link between them (Join fields), other wise it will multiply
your records.

If there is no field that link between the queris you can use sub report for
the second query.

Or, if you are looking for one value from the second query (one record) you
can use Dlookup in the ControlSource of the Text Box

=DLookUp("FieldName","QueryName")
 
Back
Top