Why does query convert "Like" criteria to "ALike"

D

dishrag86

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?
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Criteria Like 2
Getting ALike instead of Like 2
What does "Alike" in the filter criteria mean? 1
Alike operator replacing Like; I don't know why or how to fix 1
Query criteria - the Like operator 5
Alike 2
Like Converts to ALike in Query 2
Why does the like operator keep changing to alike in my queries? 1

Top