3 queries, Need Records from both even when the calculated value = 0

[BigDogTroy]

(Phone usage report) I have 3 queries, Query 1 counts number of calls in for a phone extension. Query 2 Counts the number of calls out (dialed calls). The information is keyed on the phone extension. Query 3 runs the first 2 queries (By date via parameter). Each query is keyed on Extension, I only want to see the number of calls in and out for each extension. Problem, when a phone extension being counted has no calls (In or Out), it leaves the phone extension out of the report. I want to see all the phone extensions info regardless of the count (if it = 0). Does anyone know a way around this? Thanks in advance for your help.

 

[neileg]

Include a table or query in your query that includes all possible phone extensions. Join this to your other queries using a left join (the default join in Access is an inner join which requires data on both sides of the join to return a result). You can click on the join line in the query window and select the appropriate join type.