Sue Tippett
asked on
Error when attempting to use Replace function in Access 2010 sql query
I am receiving an error when using the Replace function. I have checked the references, I included a screen shot of the references.
ReplaceFunctionIssue.docx
ReplaceFunctionIssue.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually, I did a compile. Found a issue. Working now. Just needed my brain triggered. thank you
ASKER
Compile found issue in vba code which was causing the issue. thank you
You're referencing "[Test]!Field1" in your expression. Is the Test table included in the Query you're working on?