<div>
update [dmr tracking]<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set [dmr tracking].PartCost &nbsp;= [trna part number].[Piece Cost]<br />
from [trna part number]<br />
Where [dmr tracking].[part number] = [trna part number].[Part Number]
</div>


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]

<div>
Hello, I'm getting the following error.<br />
<br />
syntax error (missing operator) in query expression '[trna part number].[piece cost] from [trna part number]'.
</div>


Hello, I'm getting the following error.

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

<div>
<div class="content wysiwyg-content">
Hello, I need a little assistance with a simple update statement.<br />
<br />
Update [dmr tracking] Set &nbsp;[dmr tracking].PartCost &nbsp;= [trna part number].[Piece Cost]<br />
Where [dmr tracking].[part number] = [trna part number].[Part Number]<br />
<br />
What am I doing wrong?
</div>
</div>


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?

update one table from another

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.