Solved

Update qry

Posted on 2011-02-20
6
874 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 143

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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

735 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