Update Query Syntax Error

[dreid1011]

Good morning,

I am working on a seemingly very simple update query and I am receiving a Syntax Error. So far, my searches have not found similar issues, so at the moment, I am lost.

The query was originally an Append query, then I clicked on the Update button on the ribbon. This is the SQL it came with:

UPDATE ASSESS_V_MS_SPECIAL_ASSESSMENT SET 
WHERE (((ASSESS_V_MS_SPECIAL_ASSESSMENT.Year)=2018 Or (ASSESS_V_MS_SPECIAL_ASSESSMENT.Year)=2019));

I made a slight adjustment to match my table name:

UPDATE ASSESS_V_MS_SPECIAL_ASSESSMENTx1 SET 
WHERE (((ASSESS_V_MS_SPECIAL_ASSESSMENT.Year)=2018 Or (ASSESS_V_MS_SPECIAL_ASSESSMENT.Year)=2019));

When I receive the error, "WHERE" is highlighted. I've tried removing the () and adding [], but no luck.

Also, while I'm at it, a couple questions:

Is SET necessary as well? If it is, I'm not sure what it should be.

Can an Update query add/remove rows?

Thank you.

 

[dreid1011]

The powers that be fixed the source table. Thank you for the suggestions though.