• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using Quotes and Pounds

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.

Quotes

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:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint