Using variables with quotes and pounds seems so simple at first glance. Yet it is amazing how much havoc and frustration these seemingly simple operations have brought to novice and advanced Access developers alike. Several ways to handle the difficulties that can arise are detailed here.
It’s ironic that the small things in Access often can be the most difficult to master. Quotes are a prime example. In some situations, quotes don’t seem that challenging. For example, if you try to create a filter using a text field, you just use an expression like this:
[State] = "Oklahoma"
At this point, there is nothing challenging in any way. You get into trouble when you try to embed a string variable inside another string. ...