Solved

Update qry

Posted on 2011-02-20
6
850 Views
Last Modified: 2012-06-21
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
Comment
Question by:pdvsa
  • 3
  • 2
6 Comments
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 100 total points
ID: 34938506
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
 
LVL 44

Accepted Solution

by:
GRayL earned 400 total points
ID: 34938570
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
 

Author Comment

by:pdvsa
ID: 34939711
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:pdvsa
ID: 34939714
updateqry
0
 

Author Comment

by:pdvsa
ID: 34939865
i am glad I made a backup up because I messed it up big time.  Good suggestion.  
0
 
LVL 44

Expert Comment

by:GRayL
ID: 34952770
Thanks, glad to help.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now