A little background, I am truly baffled on this one:
I have a simple update query with two tables with inner join. I am trying to update a field in one of the tables. After I save the query and reopen it, it does not recognize the field and labels it as "expression1". This field is...