Using Query With No Results in Another Query

[Guest]

I have several queries that sum amounts. I would like to use the results of
these queries in another query but when one of the queries has no results,
the entire "summary" query shows up as blank.
How do I get the "summary" query to show a zero when the results of the
query is empty? I have tried various NZ versions and nothing seems to work.
Example:
I have three tables: 1, 2 and 3. Each one has an Amount field. I have a
query for each table that sums the Amount field.
Then I have a Summary query that pulls:
SumAmt1, SumAmt2, SumAmt3
When one of these tables has no values then the entire query is empty.
Thanks for any help.
Ted

 

[Jeff Boyce]

If your query uses a pair of joined tables, but one of the tables has no
records satisfying the selection criteria, you won't see values from the
other... UNLESS...

Open the query in design mode. Highlight the "join" line between the
tables. Right-click it and select the option that gives you "ALL" of
table1, and "ANY" of table2.

Regards

Jeff Boyce
Microsoft Office/Access MVP