• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 895
  • Last Modified:

Update qry

Experts, I need to update tblLetterOfCredit.Amount to the value from importFeb202011.USDEquivImport where LCNo = LCNo.  

Here is part of the sql: (I need the where clause but I dont see how to add it in qry design window)  

Thank you for the help... (will be out for a few hours....)
==============
UPDATE tblLetterOfCredit INNER JOIN importFeb202011 ON tblLetterOfCredit.LCNo = importFeb202011.LCNo SET;
0
pdvsa
Asked:
pdvsa
  • 3
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I have written an article for UPDATE with JOIN:
http://www.experts-exchange.com/A_1517.html

the ms access syntax is a in the comments. ..
0
 
GRayLCommented:
Make a backup first:

UPDATE tblLetterOfCredit INNER JOIN importFeb202011 ON tblLetterOfCredit.LCNo = importFeb202011.LCNo SET
tblLetterOfCredit.Amount = importFeb202011.USDEquivImport
WHERE tblLetterOfCredit.Amount <> importFeb202011.USDEquivImport;
0
 
pdvsaProject financeAuthor Commented:
GrayL:  that worked.  in the attached screen print, I have highlighted "UPDATE TO" and it makes more sense to me if it woudl say "UPDATE FROM".  Do you see how it could be confusing?  

Angel:  thanks for the link.  It was a little above my head though... i get lost with the explanations because i dont know a whole lot about access.  I only get by with copy and paste and understanding a little bit along the way ;)
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
pdvsaProject financeAuthor Commented:
updateqry
0
 
pdvsaProject financeAuthor Commented:
i am glad I made a backup up because I messed it up big time.  Good suggestion.  
0
 
GRayLCommented:
Thanks, glad to help.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now