How to set up a paramater query with wildcarde as well in 1feild?

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

Guest

ACCESS 2000 QUERY HELP

I want to make a parameter query that takes the first part of the parameter
and wildcard search for any further matching feilds, to use in a surname
search -
so that [mi] will return any mi* ie micke, mickel, michell and so on..
 
Am Fri, 30 Sep 2005 06:20:04 -0700 schrieb Abadious:

use a query like this:
"select mi from
where mi like 'abc*'

For further assistance please contact an Access or SQL related news
group. This one is for Outlook VBA.
 
Back
Top