I need to update a field with the contents of 2 other fields when exiting a record. The fields (ItemNo) and (LotID) need to create or update the field (LotCode). ie: ItemID (GM-235), LotID (26) will result in LotCode (GM-235-26). I currectly use a Update Query that uses the expression...