Set Record Source to two queries?

X

XP

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

Ofer Cohen

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Translating Query formatting 2
assign record source 5
How to add more that one tables or queries to report record source 6
Record Source not showing field names 4
set record source of subreport 4
Form filter with multi-column combo box in report 0
Form filter with multi-column combo box does not work in report 0

Top