I need to update the tblLetterOfCredit.Amount to the value from Import_LC_Amount but only for tblLetterOfCredit.Currency = USD.
tblLetterOfCredit.Currency has a row source qry of:
SELECT tblCurrencyExchange.CurrencyID, tblCurrencyExchange.Currency FROM tblCurrencyExchange;
this is what I have now joined on [LCNo] to [JP Morgan Reference] and need the USD part:
UPDATE IMPORT_LC_AMOUNTS INNER JOIN tblLetterOfCredit ON IMPORT_LC_AMOUNTS.[JP Morgan Reference] = tblLetterOfCredit.LCNo SET tblLetterOfCredit.Amount = [Import_LC_Amount].[Issued amt];
anything else please let me know