How to set up search form using WILDCARDS in data access page?

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

Guest

I am designing in Access2003. A simple parameter query using LIKE and "*"
does not work. I realize a different engine reads the query and doesn't read
the wildcards. What can I do? Different ANSI code?
 
I am designing in Access2003. A simple parameter query using LIKE and
"*" does not work. I
Click to expand...

Depends on the library you are using. ADODB uses standard % and _ for
wildcards, while DAO still uses DOSalike * and ?

Hope that helps


Tim F
 
Back
Top