"JayTee" wrote in
:

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

Because you're using ALIKE instead of LIKE. ALIKE exists to allow
you to use SQL Server compatible wildcards, in which case you'd use
% in place of * and _ in place of ?.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/