Is that query generating an error or it's working but not giving you the desired results ?
Have you tried using '%' as the wildcard instead of '*' ?
<a href="http://articles.techrepublic.com.com/5100-10878_11-6154704.html">Here</a> is an interesting article about the wildcard characters when using MS Access (See # 8: Accommodate SQL conflicts).
You might also want to take a look at <a href="http://msdn.microsoft.com/en-us/library/aa140104(office.10).aspx">this</a> and/or <a href="http://msdn.microsoft.com/en-us/library/bb208890.aspx">this</a>
Hope this helps.
Last Wiki Answer Submitted: September 23, 2008 2:57 pm by carlosdl63,535 pts.