Using Google, I found the following update query posted by Tony Hopkinson in Mar 2005:
update mytable set ssn = right$(ssn,4)
I tried this and it works for all MS Access databases that I have except for one. In that database, I get the following error when I run the query:
Compile error. in query xpression ‘right$(ssn,4)
Any suggestions would be greatly appreciated.
Semper Fidelis,
Joe Grabman
