I have a query that I have been using for several years without any issues, recently I have noticed that some records are missing (not sure if is something that I have done while making some adjustments)
There are 2 tables "Completed_Jobs_Addressed" and "Payments"
SELECT Completed_Jobs_Addressed.Completed_Date, Completed_Jobs_Addressed.JobNo, Completed_Jobs_Addressed.Address, Completed_Jobs_Addressed.Job_Outcome, Completed_Jobs_Addressed.Tech_Name, Completed_Jobs_Addressed.Comments, Payments.Job_No
FROM Completed_Jobs_Addressed LEFT JOIN Payments ON Completed_Jobs_Addressed.JobNo = Payments.Job_No
WHERE (((Payments.Job_No) Is Null))
ORDER BY Payments.Job_No DESC;
If the "Payments.Job_No" is blank the record is not displayed.
I have tried Nz([Payments.Job_No],"1") when the query is run it converts this field to 1 if it is blank, the aim was then to do greater than 1but I can't get it to work.
Is there a more efficient method of achieving my goal.
Geoff
There are 2 tables "Completed_Jobs_Addressed" and "Payments"
SELECT Completed_Jobs_Addressed.Completed_Date, Completed_Jobs_Addressed.JobNo, Completed_Jobs_Addressed.Address, Completed_Jobs_Addressed.Job_Outcome, Completed_Jobs_Addressed.Tech_Name, Completed_Jobs_Addressed.Comments, Payments.Job_No
FROM Completed_Jobs_Addressed LEFT JOIN Payments ON Completed_Jobs_Addressed.JobNo = Payments.Job_No
WHERE (((Payments.Job_No) Is Null))
ORDER BY Payments.Job_No DESC;
If the "Payments.Job_No" is blank the record is not displayed.
I have tried Nz([Payments.Job_No],"1") when the query is run it converts this field to 1 if it is blank, the aim was then to do greater than 1but I can't get it to work.
Is there a more efficient method of achieving my goal.
Geoff