Page 7 of 10PREVNEXT

Queries VI: Use wildcards in queries and parameters

Ways to find wildcard characters in your data

To find wildcards, wrap them in brackets.

What if your data itself contains wildcard characters, and you need to find those characters? For example, a company name may contain brackets, such as "Fabrikam Inc. [GmbH]".

By default, Access treats wildcards in your data as actual wildcards, instead of characters you want to find. But don't fret, there is a solution.

To include wildcards in your query results, surround them with brackets when you enter your criteria. The picture shows you some examples of how to find wildcards in your data, and the Quick Reference Card tells you even more.

Page 7 of 10PREVNEXT