How do I join 2 queries in one report?

J

jmenp

How do I use two queries in one report. If I base the report on only one of
the queries then I get an error when I try to use a total from another query.
I can't figure out what I'm doing wrong.
 
T

tina

you could try linking the two queries in a third query, and using that query
as the RecordSource for your report. or you could use the DLookup() function
to pull the value from the "other" query and show it in a control in your
report.

hth
 
Top