|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 15th, 2009, 04:41 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Why does query convert "Like" criteria to "ALike"
Sometimes queries seem to go corrupt and when I type "Like" (without quotes)
into my criteria as soon as I click out of that criteria, it changes to "ALike". Any ideas? 
|
|
#2
December 15th, 2009, 09:29 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Why does query convert "Like" criteria to "ALike"
Uncheck the option to use "SQL Server Compatible syntax."
In Office 2007, click the Office button (top left) and then Access Options (bottom of dialog.) In earlier versions, it's Tools | Options. -- 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. "dishrag86" wrote in message ... Sometimes queries seem to go corrupt and when I type "Like" (without quotes) into my criteria as soon as I click out of that criteria, it changes to "ALike". Any ideas?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
