• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Working with Queries > Querying with Wildcards

Querying with Wildcards

Wildcards are characters that represent one or more characters in an expression. For instance, to query an Authors table to find names beginning with "B," just set your criteria to B∗. The asterisk tells Access to find every record where the value in the LastName field begins with the letter "B" and is followed by any other character.

The three wildcard characters you'll use most often are the asterisk (∗), which matches any number of characters ("Bl∗" returns Blank, Block, and Bly, but not Barnum); the question mark (?), which matches any single character ("Bl?ck" returns Black and Block, but not Blosovick); and the pound sign (#), which returns any numerical character ("199#" finds 1999 and 1998, but not 1989).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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