Criteria to search any part of the field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I use to use this criteria to make searches in my query. This allow me
put search records that has that criteria.

Search form "laptop" it will show:

"Asus Laptop" and "This is a HP Laptop"

For some reason is not working anymoe
ALike "*" & [Forms]![4_form_Goods_View]![Goods_Name] & "*"

The problem is that it's not working anymore.

Anyone knows way?

Regards,
Marco
 
I believe with ALike you need to use "%" as the wildcard instead of "*" and
use "_" in place of "?".

Hope that helps.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how make a select with a AND in columns 1
Criteria in a Querie 8
Compound Search Criteria Using a Form 1
Criteria is not working 3
use field list from form to specify query fields 2
part of multi search query non-functional 4
NOT LIKE search criteria 13
Search part of name field 0

Back
Top