troubleshooting Question

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

Avatar of stephenlecomptejr
stephenlecomptejrFlag for United States of America asked on
SQL
2 Comments1 Solution702 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros