Query Prob - Please HELP

[isv_2004]

How do I use a wildcard in a query, see attached .mdb

Table "myDATA"
Sam and Zeb have serial number 23a4224A and 23a4224 in their records.

I want to locate a serial number(s) in multiple fields of a table, based on the users input with a wildcard.

query "Serial Number query"
Enter Serial Number: the user enters: 23a4224*

What am I doing wrong?

Thanks

 

[rmd_nj]

Try adding the word "Like" (minus the quotes) before each criteria.
Bob

 

[isv_2004]

Still need help!

Please see the attached file, the Like argument will not work in this example.

Anyone?

 

[SMatthews]

Change your criteria from [Enter Serial Number] to Like [Enter Serial Number] & "*"

 

[isv_2004]

Thank you

SMatthews,

Thank you very much, it worked great!

ISV_2004