View Single Post
  #3  
Old May 27th, 2010, 02:42 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Wild card not working in Access 2010 query

On Wed, 26 May 2010 23:42:52 GMT, "JayTee" wrote:

Hi all,
I am wondering if anyone out there knows why the wild card (*) will not work
in an MS Access 2010 query.

I tried, as I have for years, to enter a criteria in a query as follows:
Like "*" & [Forms]![FormName]![FieldName] & "*"
And it creates this
ALike "*" & [Forms]![FormName]![FieldName] & "*" and then won't work
Please help someone as I am at my wits end.
Thanks in advance

JayTee


Sounds like you've set the database's properties to use SQL/92 format queries
(not sure just how it phrases it). The ALike is the clue. ALike is equivalent
to the SQL/Server syntax of LIKE, and uses % rather than * as the "match any
string" wildcared (also it uses _ rather than ? as the match a single
character). See the online Help for "ALIKE".
--

John W. Vinson [MVP]