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.

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.