Using wildcards in queries in Microsoft Access 2019

Wildcard characters are special characters that can be used when youare not sure how to spell a word or when you wish to find similar-typewords that start with the same character. These characters make yoursearch more powerful and flexible. Here are two examples of wildcardcharacters:

  • * or %: Matches any number of characters. The* can be used anywhere in a character string—see the example inthe table in the Compiling query criteria section.
  • ? or _: Matches any single alphabeticalcharacter.

There are many different types of wildcard characters that can beused in queries. The aforementioned examples are just a few to get youthinking! Let’s take a look at how to create a parameter query in thenext topic.

Leave a Comment