This sort of thing is more safely done using Visual Basic and Data Access Objects. What I understand you to want is to read a record, update the field in the record and save it. I don't think this can be done reliably with an update query.
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.