I keep getting the error "Ambiguous name in query expresion. 'Swap([Diamond]'. When I try to execute the following query. It's telling me that there is a mispelling or something of that nature. What am I missing?
UPDATE STAGE_INST_HDR SET STAGE_INST_HDR.ALIAS = Swap([Diamond Id])
WHERE ((Not (STAGE_INST_HDR.[Diamond Id]) Is Null));