Previous Thread:   VBA and Outlook Note Items

9/30/2005 6:20:04 AM    How to set up a paramater query with wildcarde as well in 1feild?
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..



10/3/2005 6:09:43 PM    Re: How to set up a paramater query with wildcarde as well in 1feild?
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.  
  
--  
  
Viele Gruesse / Best regards  
  
Michael Bauer - MVP Outlook  
  
parameter  
  
surname