Microsoft Office Tutorials and References
In Depth Information
Finding data using the form
c u rrent
specifies that Access will
search for the value in any
part of the current field
6. Click the Find Next button. The Customer Data form now displays record 35,
which is the record for the Three Tulips Café (Customer ID 11080). The word
“Tulips” is selected in the Company field value because you searched for this word.
Oren reviews the information for the record and determines it is correct.
The search value you enter can be an exact value or it can include wildcard
characters. A wildcard character is a placeholder you use when you know only part of a
value or when you want to start or end with a specific character or match a certain
pattern. Figure 4-13 shows the wildcard characters you can use when finding data.
Match any number of characters. It can
be used as the first and/or last character
in the character string.
th* finds the, that, this, therefore, and so on
Match any single alphabetic character.
a?t finds act, aft, ant, apt, and art
Match any single character within the
a[fr]t finds aft and art but not act, ant, and apt
Match any character not within brackets. a[!fr]t finds act, ant, and apt but not aft and art
Match any one of a range of characters.
The range must be in ascending order (a
to z, not z to a).
a[d-p]t finds aft, ant, and apt but not act and art
Match any single numeric character.
#72 finds 072, 172, 272, 372, and so on
Next, Oren wants to view the customer records for any customers with phone num-
bers beginning with the area code 517. He is curious to know how many customers are
in cities serviced by that area code, and what the cities are. You could search for any