<div>
I guess I had it wrong. &nbsp;I am updating tblLetterofCredit<br />
<br />
Update tblLetterOfCredit<br />
SET tblLetterOfCredit.Amount = [Import_LC_Amount].[Issued<wbr /> amt];<br />
from tblLetterOfCredit<br />
Where tblLetterOfCredit.Currency<wbr /> = [Import_LC_Amount].[Currre<wbr />ncy]<br />
<br />
See something wrong with that?<br />

</div>


I guess I had it wrong.  I am updating tblLetterofCredit

Update tblLetterOfCredit
SET tblLetterOfCredit.Amount = [Import_LC_Amount].[Issued amt];
from tblLetterOfCredit
Where tblLetterOfCredit.Currency = [Import_LC_Amount].[Currrency]

See something wrong with that?


<div>
Should work<br />
As always, backup your database before making any mass updates like that.
</div>


Should work
As always, backup your database before making any mass updates like that.

<div>
<div class="content wysiwyg-content">
Experts, <br />
<br />
I need to update the tblLetterOfCredit.Amount to the value from Import_LC_Amount but only for tblLetterOfCredit.Currency<wbr /> = USD.<br />
<br />
tblLetterOfCredit.Currency<wbr /> has a row source qry of:<br />
SELECT tblCurrencyExchange.Curren<wbr />cyID, tblCurrencyExchange.Curren<wbr />cy FROM tblCurrencyExchange; <br />
<br />
this is what I have now joined on [LCNo] to [JP Morgan Reference] and need the USD part:<br />
UPDATE IMPORT_LC_AMOUNTS INNER JOIN tblLetterOfCredit ON IMPORT_LC_AMOUNTS.[JP Morgan Reference] = tblLetterOfCredit.LCNo SET tblLetterOfCredit.Amount = [Import_LC_Amount].[Issued<wbr /> amt];<br />
<br />
anything else please let me know<br />
Thank you<br />

</div>
</div>


Experts, 

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
Thank you


Update Qry

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.