This Update Works
-----------------------------------------------------------------
update sales_ter_email
set sales_email ="bristaino@yankeeequipment.com"
and sales_person ="Brendan Ristaino"
Where city = "arlington"
and state ="MA"
-----------------------------------------------------------------
This one does not
-----------------------------------------------------------------
update sales_ter_email
set sales_email ="bristaino@yankeeequipment.com"
and sales_person ="Brendan Ristaino"
Where city = "arlington"
and city = "ayer"
and state ="MA"
------------------------------------------------------------------

is what I am trying to do possible?

there should be no problems doing the second if the first works properly.
Do you actually have a row that meets the criteria set out in the second update statement?

Yes I have an ayer and an arlington row in the city column. But I just found out that my first is not updating but clearing the data, so no I am back to the beginning, again.

got it, no "and" in the set funtion