Jan 10 2006, 05:57 PM
can i do a wild card search in a query table ie.. when my query asks for manufacture can i put "wa*" and it will list everything that starts with a wa?
Jan 10 2006, 06:02 PM
On the criteria add in something like
LIKE [Please enter Your Seach Criteria] & "*"
Just change "Please enter Your Seach Criteria" to whatever you want it to ask them for.
You could also create a form and reference that by replacing
[Please enter Your Seach Criteria]
Using a form allows you more control over what the user has input and allows for validation.
Jan 10 2006, 06:04 PM
Again, thank you, i will try this at work. you guys are great
Jan 10 2006, 06:10 PM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here