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]
|