Do you know how to develop a parameter query that allows the uer to enter a
wildcard in the parameter dialog value box?
Use a criterion of
LIKE [Enter search term:]
If the user enters
*X*
they'll find all records where the field contains the letter X
anywhere in it.
It's the LIKE operator that controls whether wildcards work. LIKE
honors wildcards; the default = operator treats * as a literal
asterisk character.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
