ALike is a very poorly documented "feature" that allows Access to use the %
wildcard as SQL Server does. You might find that the query works if you use:
ALike [Last name?] & "%"
You might also like to see if it makes any difference to uncheck the box
under:
Tools | Options | Tables/Queries | SQL Server Compatible Syntax
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Strasser" <wi******************@hotmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
Problem: Query record selection criteria reads Like [Last name?] & "*"
BUT, then Access changes it to non-functioning Alike [Last name?] &
"*"
Any ideas?
Thank you in advance.
Strasser