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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Abadious - 30 Sep 2005 14:20 GMT

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..

Reply to this Message

Michael Bauer - 03 Oct 2005 17:09 GMT

Am Fri, 30 Sep 2005 06:20:04 -0700 schrieb Abadious:

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

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

Signature

Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

> 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..

Reply to this Message