Merge 2 queries with null? values

[PrintShopSup]

Our billing database has transaction records that provide data that shows where an order is placed (print shop) and where it is printed (tranferred orders). I use 2 queries to total some data (count of orders and sum of charges) and then another query which "merges" the 2 queries to provide "Ordered vs Printed" data. The company closed 2 print shops this year. Data is still collected from those locations (ordered in) but will not show those shops in the "Printed in" query. Is there a way to modify the "Printed" query to put zeros "0" so that my "merge" query will still show the ordered totals?



I exported the data, modified it for this forum, and attached the data here for reference. Any insight would be appreciated as I am currently manually adding these records in my report to management.

[June7]

Change your query jointype to Left:
LEFT JOIN qryShopTotals_Printed ON (qryShopTotals_Ordered.fldPrintShopOrdered = qryShopTotals_Printed.fldCurrentPrintShopmod) AND (qryShopTotals_Ordered.fldMonth = qryShopTotals_Printed.fldMonth) AND (qryShopTotals_Ordered.fldYear = qryShopTotals_Printed.fldYear)

Then deal with the null values in the calculation with Nz function.
expNetDiffCharges: Nz([expTotalChargesPrinted],0)-Nz([expTotalChargesOrdered],0)

[PrintShopSup]

Well, I was headed in the right direction. All joins need to be left join. I started using only the print shop as the left join and got the "ambigous" join error. Thanks for helping out. It is a "georgeous" query.