There’s an old saying that goes “You learn something new every day”. That’s fine, but it’s embarrassing when what you learned that day is something that you should have learned years ago.
I recently was working with Access when I ran into a situation I’ve never run into before. As I did some research, it became clear that this “problem” I was having seemed to be common knowledge.
It revolved around special characters. Since we all have things to do today, I’ll simplify the scenario to a basic example.

