Solved

update one table from another

Posted on 2013-11-18
4
233 Views
Last Modified: 2013-11-18
Hello, I need a little assistance with a simple update statement.

Update [dmr tracking] Set  [dmr tracking].PartCost  = [trna part number].[Piece Cost]
Where [dmr tracking].[part number] = [trna part number].[Part Number]

What am I doing wrong?
0
Comment
Question by:gogetsome
  • 2
4 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 39657731
update [dmr tracking]
      set [dmr tracking].PartCost  = [trna part number].[Piece Cost]
from [trna part number]
Where [dmr tracking].[part number] = [trna part number].[Part Number]
0
 

Author Comment

by:gogetsome
ID: 39657740
Hello, I'm getting the following error.

syntax error (missing operator) in query expression '[trna part number].[piece cost] from [trna part number]'.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39657743
or this:


Update [dmr tracking], [trna part number] 
Set  [dmr tracking].PartCost  = [trna part number].[Piece Cost]
Where [dmr tracking].[part number] = [trna part number].[Part Number]

Open in new window

0
 

Author Closing Comment

by:gogetsome
ID: 39657748
Thanks man! You rock!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
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…
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…

708 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

13 Experts available now in Live!

Get 1:1 Help Now