Ok, I've managed to get it. Using the query below, I then did a Right Join as shown below to list all records and then filter out those with the JobTypeID=2 and JobStatus="0":
SELECT C.CustomerID, QC.KountComplete, C.NameNumb, C.BillingAddress, C.City, C.PostalCode
FROM qryCountCompleteServices AS QC RIGHT JOIN Customers AS C ON QC.CustomerID = C.CustomerID
WHERE (((C.Owner)=6218) AND ((C.BlockCustomer)=0) AND ((QC.KountNA) Is Null));
The Owner and BlockCustomer were added after the event to further filter.