I have the following simple update statement in an Access (2021) query:
UPDATE Patrons INNER JOIN PatronsWork ON Patrons.PatronID=PatronsWork.PatronID SET Patrons.Zip = PatronsWork.Zip;
I've found numerous examples of update statements exactly like it on various web sites, and can think of no way to simplify it further. When I run it, I'm always getting the following error:
"An argument to the Updated function was invalid. The field name must be provided as a string value enclosed in quotation marks."
Just to be clear, none of the field names in either table contain anything but upper and lower case letters. Also, adding brackets ( [Patrons].[Zip] ) makes no difference.
I've been banging my head on this wall for hours. Any help would be massively appreciated.
UPDATE Patrons INNER JOIN PatronsWork ON Patrons.PatronID=PatronsWork.PatronID SET Patrons.Zip = PatronsWork.Zip;
I've found numerous examples of update statements exactly like it on various web sites, and can think of no way to simplify it further. When I run it, I'm always getting the following error:
"An argument to the Updated function was invalid. The field name must be provided as a string value enclosed in quotation marks."
Just to be clear, none of the field names in either table contain anything but upper and lower case letters. Also, adding brackets ( [Patrons].[Zip] ) makes no difference.
I've been banging my head on this wall for hours. Any help would be massively appreciated.