How do I join 2 queries in one report?

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

Guest

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.
 
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
 
You must log in or register to reply here.

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

Using select and crosstab queries on one report 1
update cross tab query in a report 7
Report combiones all records 3
Access Access Report Works on One Machine but not Another 3
Joining queries 1
Count funtion in report-I'm too rusty! 1
Can't create a report from my query in Access 1
Joining 2 Queries in One Report 5

Back
Top