UPDATE Statement Correct Syntax

[OMGsh Y did I say Yes]

Good morning,

I would like to write an UPDATE Statement properly and wondered if anyone would mind helping? Here's my totally nebbie logic:

UPDATE - TAT (field) in QuoteLineItems2 (table)
SET - TAT (field) = QuoteHeading (form)

What am I trying to do? Move data from a form into a table with an UPDATE.



Thanks in advance for your consideration.

[maximus]

here is a typical Update Query SQL syntax:

UPDATE Table1 SET Table1.Employee_Status = [Forms]![Form1]![Status]
WHERE Table1.Employee_ID=2;

Table1 is the name of the Table

Employee_Status is the Field in the table that I want to Update. You will notice that this is written after SET. The value of the Control Status on Form Form1 is taken to update employee status.

The Criteria of Update follows the WHERE. If you leave the Where Clause out of the SQL update query then all of the records will get updated.

To lear more about update Queries follow the link below.

http://www.blueclaw-db.com/accessque...tement_sql.htm

[OMGsh Y did I say Yes]

Thank you Maximus!!