Solved

update query

Posted on 2011-02-22
2
210 Views
Last Modified: 2012-05-11
I have table TUBEDATA where each record has fields PartNumber and SerialNumber.

I have a second table CURRENT LOCATION with fields PartNumber and SerialNumber.  The records all have the SerialNumber but none the PartNumber

I need an update query to update all the records in table CURRENT LOCATION with PartNumber from table TUBEDATA.

Thanks,
Brooks
0
Comment
Question by:gbnorton
2 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
try this update query

update [CURRENT LOCATION] as CL
Inner join TUBEDATA as TD
on CL.SerialNumber= TD.SerialNumber
set CL.Partnumber=TD.PartNumber
where CL.PartNumber is null
0
 

Author Closing Comment

by:gbnorton
Comment Utility
Perfect.  Thanks!
Brooks
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

744 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

9 Experts available now in Live!

Get 1:1 Help Now