Forum Discussion
SheriO7043
Mar 20, 2024Copper Contributor
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...
SheriO7043
Mar 20, 2024Copper Contributor
Thank you. I have only tried the query against my database. I'll try creating a new database -- maybe this one (I adopted) is corrupt somehow... I'll get back to you.
SheriO7043
Mar 20, 2024Copper Contributor
It looks like its the database that's bad, not expressions. Thank you so much for the nudge! 🙂