wildcards
~~~
Hi Gordon,
instead of letting Access correct your entry for quotes, type them in
yourself
criteria --> Like "pattern"
where
pattern is the pattern you are looking for and contains wildcards
Wildcards for ANSI-89
Wilcards give us the ability to create a pattern to look for (also
called a mask). Here are some symbols you can use in your mask:
*
Match zero or more characters; use as first or last character of a mask.
?
Match a single alphabetic character.
[charlist]
Match a single character specified in the character list within the
brackets.
[A,B,C,D] is the same as [A-D]
[!charlist]
Matches any character NOT in the character list within the brackets.
[x-y]
Match any character in a specified range from 'x' to 'y' (range must be
stated in ascending order, A-Z, 0-100)
#
Match a single numeric character.
If the data is stored in, for instance, Microsoft SQL Server instead of
Access, you will need to use ANSI-92 Wildcards.
~~~~~~~~~~~~~~~~~~~~~
pattern examples
"*word*" --> everything containing 'word'
"Start*" --> everything that starts with 'Start'
"*End" --> everything that ends with 'End'
"[a,b,c,d]?[1-9, a-c]*" -->
first character is a,b,c, or d
second character is anything
third character is 1,2,3,4,5,6,7,8, 9, a, b, or c
then, it can be anything or nothing
"??D*" --> third character is 'D'
Warm Regards,
Crystal
Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm
*
![Smile :) :)](/styles/default/custom/smilies/smile.gif)
have an awesome day
![Smile :) :)](/styles/default/custom/smilies/smile.gif)
*