Solved

Update qry

Posted on 2011-02-20
6
861 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
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…

813 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

17 Experts available now in Live!

Get 1:1 Help Now