Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
Dim strSQL5 As String Dim liTotalCost As Long Dim liBalMD As Long Dim liEstMD As Long Dim liActMD As Long liBalMD = (CDbl([A]) + CDbl([B]) + CDbl([C]) liEstMD = (CDbl([X]) + CDbl([Y]) + CDbl([Z]) If liBalMD < 0 Then liActMD = (liEstMD + liBalMD) Else liActMD = liEstMD End If liTotalCost = (CDbl([ActMDCost]) - liActMD) strSQL5 = "Update DISTINCTROW [ProjOverview] o Left Join (SELECT ProjID, SUM(Amount) AS SumOfAmount From JONProjJoins GROUP BY ProjID) s ON s.ProjID = o.IDNmbr Set [Status] = 'Complete', [Complete] = Now , [TotalServicesAct] = [TotalServicesEst] Where (([Status] = 'Funded') AND (" & liTotalCost & " > Nz(s.SumOfAmount, 0))) OR (([Status] = 'Funded') AND (" & liTotalCost & ") > ([TotalEstimate]))" DoCmd.RunSQL strSQL5
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.