Email field name weirdness...HELP!

[Dave Cobb]

I have a filed named (e-mail address removed)

 

[Ken Snell [MVP]]

Assuming that what you posted is the syntax you now have, try an update
query like this:

UPDATE TableName
SET = Left([Email], InStr([Email], "#") - 1)
WHERE InStr([Email], "#") > 0;