How can i setup a perameter query that will allow a wildcard (*)?

C

casper128g

I would like to setup a perameter query that will a value like "DA*" and will
return david,dave,dan,daniel. Everytime i try this it it returns 0 records.
It is almost as if it is actualy looking for the * in the name instead of
using it as a wildcard. Is there a way to do this?
 
D

Dennis

In your criteria row of the first name column in your query, put this
Like [Enter Start Chars.] & "*"

Run your query and type in DA when prompted and you should get the records
expected.
 
Top