INSERT INTO tblLetterOfCredit ( ProjectID, ExpiredYN, LCNo )
SELECT [import-CSM2].ProjID, IIf([Import-CSM2]![Actual Status]="GEC",Yes,No) AS ExpiredYN, [import-CSM2].[Reference Number]
FROM [import-CSM2] LEFT JOIN tblLetterOfCredit ON [import-CSM2].[Reference Number] = tblLetterOfCredit.LCNo
WHERE ((([import-CSM2].ProjID) Is Null) AND ((IIf([Import-CSM2]![Actual Status]="GEC",Yes,No))=0) AND ((tblLetterOfCredit.LCNo) Is Null));
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.