G Guest Dec 16, 2004 #1 Do you know how to develop a parameter query that allows the uer to enter a wildcard in the parameter dialog value box?
Do you know how to develop a parameter query that allows the uer to enter a wildcard in the parameter dialog value box?
P PC Datasheet Dec 16, 2004 #2 Put your parameter in the criteria like this: [Enter Parameter Here] & "*"
J John Vinson Dec 17, 2004 #3 Do you know how to develop a parameter query that allows the uer to enter a wildcard in the parameter dialog value box? Click to expand... 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
Do you know how to develop a parameter query that allows the uer to enter a wildcard in the parameter dialog value box? Click to expand... 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
