<div>
the keyword SET is to be used ONCE:<br />
<br />
UPDATE [PROJ_RM] SET [Room_Number] = '1.000.00.L', [Updated] = True <br />
WHERE [PROJ_RM].[Room_Number] = '1S-2' AND [PROJ_RM].[Updated] = False
</div>


the keyword SET is to be used ONCE:

UPDATE [PROJ_RM] SET [Room_Number] = '1.000.00.L', [Updated] = True
WHERE [PROJ_RM].[Room_Number] = '1S-2' AND [PROJ_RM].[Updated] = False

<div>
<div class="content wysiwyg-content">
Having trouble with the following SQL statement. &nbsp;Microsoft Access 2003 keeps giving me Run-time error '3144' - syntax error in update statement with the following: &nbsp;The [Room_Number] field has a data type of text with field size of 50 and [Updated] field is a yes/no.<br />
<br />
UPDATE [PROJ_RM] SET [Room_Number] = '1.000.00.L', SET [Updated] = True WHERE [PROJ_RM].[Room_Number] = '1S-2' AND [PROJ_RM].[Updated] = False<br />

</div>
</div>


Having trouble with the following SQL statement.  Microsoft Access 2003 keeps giving me Run-time error '3144' - syntax error in update statement with the following:  The [Room_Number] field has a data type of text with field size of 50 and [Updated] field is a yes/no.

UPDATE [PROJ_RM] SET [Room_Number] = '1.000.00.L', SET [Updated] = True WHERE [PROJ_RM].[Room_Number] = '1S-2' AND [PROJ_RM].[Updated] = False


Run-time error '3144' - syntax error for a SQL statement in Microsoft Access 2003

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.