1 2 3
| SELECT dbo_QOHdr.sonbralt, dbo_Customers.CustCode, dbo_Customers.Name, dbo_roadsheet.c_todenounce, dbo_QOHdr.approvedatesent, dbo_vContractSummary.poutrelles, dbo_vContractSummary.poutres, dbo_vContractSummary.murs, dbo_vContractSummary.fermes, (dbo_vContractSummary.poutrelles+dbo_vContractSummary.poutres+dbo_vContractSummary.murs+dbo_vContractSummary.fermes) AS TOTAL
FROM dbo_Customers INNER JOIN (dbo_QOHdr INNER JOIN dbo_roadsheet ON dbo_QOHdr.roadsheetid = dbo_roadsheet.roadsheetid) ON dbo_Customers.CustId = dbo_roadsheet.custid, dbo_vContractSummary
WHERE (((dbo_QOHdr.sonbralt)=[dbo_vContractSummary]![sonbralt]) AND ((dbo_QOHdr.approvedatesent)>=#1/1/2015#) AND ((RechDom("[Sonbralt]"; "[Contrat_NePasDenoncer]"; "[Sonbralt]=" & dbo_QOHdr.sonbralt)) = Null)); |