I created an Update query in Access, where (when certain conditions apply), two fields should trade values. In the Update row of the query builder, I put the appropriate destination fields.
However, after I run the query, both fields have the same value. It looks like it first does one, and then copies it back.
Is there a way to do what I'm aiming for?