|
Home > Archive > MS Access database support > April 2006 > query prompt w wild card-Prb is like changes to Alike
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
query prompt w wild card-Prb is like changes to Alike
|
|
| Strasser 2006-04-04, 7:43 am |
| 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
| |
| Allen Browne 2006-04-04, 7:43 am |
| 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" < williamstrasserfranz
@hotmail.com> wrote in message
news:1144152998.196235.321900@u72g2000cwu.googlegroups.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
| |
| Strasser 2006-04-07, 11:32 am |
| Alike [Last name?] & "%" works perfectly!
Thank you so much!
Strasser
|
|
|
|
|