You can only update one table at a time, but you can update multiple fields within the same record.
e.g. UPDATE MyTable SET Field1 = 1, Field2 = 2 WHERE Field1 = 0
See the help (Access & SQL BOL) for further information.
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.