Improve company productivity with a Business Account.Sign Up

x
?
Solved

Update qry

Posted on 2011-02-20
6
Medium Priority
?
897 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 400 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 1600 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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 

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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

608 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