![]() ![]() Wh* finds what, white, and why, but not awhile or watch. You can use the asterisk ( *) anywhere in a character string. Here are some examples of wildcard characters for Access queries: For example, finding everyone named John on Park Street.įor more information about queries, see introduction to queries. Wildcards can also help with getting data based on a specified pattern match. Wildcards are special characters that can stand in for unknown characters in a text value and are handy for locating multiple items with similar, but not identical data. To locate a specific item when you can't remember exactly how it is spelled, try using a wildcard character in a query. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.
0 Comments
Leave a Reply. |