Here is the SQL statement I currently have:
SELECT tblEqpt.EqptID, NZ([Amount],"0") AS CalcAmount, NZ([COAmount],"0") AS CalcCOAmount, NZ([InvoiceAmount],"0") AS CalcInvoiceAmount, (NZ([Amount])+NZ([COAmount])-NZ([InvoiceAmount])) AS [Amount Remaining]
FROM tblReq INNER JOIN ((tblEqpt INNER JOIN tblChangeOrder ON tblEqpt.EqptID = tblChangeOrder.EqptID) INNER JOIN tblInvoice ON tblEqpt.EqptID = tblInvoice.EqptID) ON tblReq.ReqID = tblEqpt.ReqID
2 possibilities will exist
1. tblChangeOrder may not have any rows
2. tblInvoice may not have any rows
If this is the case, I need the calculation to be performed just as if [COAmount] were 0 and [InvoiceAmount] were 0.
I thank you in advance for your assistance.