I would like to update a field in an Access table using the SQL
update command.
The following syntax will work if I want to update a specific value
in a field.
UPDATE CustomerTable
SET City = Atlanta
Where Zipcode = 30303
Could anyone tell me the correct syntax to set city = a variable like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.