Access Query Expressions not working: Replace, InStr

I am trying to run a relatively simple query and receive a compile error. The two fields involved are both text fields.   SELECT Spouse, Replace(Spouse, Last, "") AS Result FROM SimplifiedTable...