Depending on how you're using it, you may need to use % as the wildcard, not
*.
--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)
"JayTee" wrote in message
...
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