Query changes Like to Alike

[justineld]

I am working in 2007 and the oddest thing in my query - I am trying to find a part no LIKE and it keeps changing it to ALIKE and result nothing. Is this a new anomaly in Access? I have another db that does not change this. Appreciate

 

[boblarson]

I am working in 2007 and the oddest thing in my query - I am trying to find a part no LIKE and it keeps changing it to ALIKE and result nothing. Is this a new anomaly in Access? I have another db that does not change this. Appreciate

What is the exact criteria you are trying to use? And what is the field name?

 

[justineld]

the field is called Part and there is are many Dunnage(then numbers) to the part. It works in another db with the following - but when I tried importing this query to this other one - it changed it...
SELECT tPSDIvd.tivdpEID, tPSDIvd.tivdpMonthIVD, tPSDIvd.tivdpIvdAmt
FROM tPSDIvd
WHERE (((tPSDIvd.tivdpPart) Like "dunnage*" Or (tPSDIvd.tivdpPart) Like "vac*"));

 

[boblarson]

I don't see any reason why it should. You might try replacing the SQL with this (sans parens):

SELECT tPSDIvd.tivdpEID, tPSDIvd.tivdpMonthIVD, tPSDIvd.tivdpIvdAmt
FROM tPSDIvd
WHERE tPSDIvd.tivdpPart Like "dunnage*" Or tPSDIvd.tivdpPart Like "vac*";

Other than that - are all of the fields available exactly as named in the table? Perhaps you have some corruption going on.

 

[justineld]

Hey Bob - let me just say that I am usually a "ghost" on these sites (it is intimidating ) and I always read YOU!
That didn't work - it is just so odd that it would physically change the LIKE to ALIKE. I will continue to play but THANK YOU FOR ALL THE RESPONSES TO EVERYONE (I am feeling universal despite mayhem)

 

[boblarson]

Just curious but do you have a non-English version of Access? I have not seen that "Alike" problem before, but if you can upload, even a stripped down copy of the database, it might be helpful.

 

[justineld]

No it is English - I was actually reworking something that worked The query is called query2 - Actually states the UPLOAD Failed a few times - and this was stripped down!

 

[boblarson]

No it is English - I was actually reworking something that worked The query is called query2 - Actually states the UPLOAD Failed a few times - and this was stripped down!

You need to use the Compact and Repair and then you need to ZIP it. If you have WinXP or Vista you can just right click on the file and select SEND TO > COMPRESSED FOLDER and that will zip it. But first do a COMPACT AND REPAIR to make sure it is as small as possible before zipping.

 

[boblarson]

Oh, and since it is in 2007, I won't be able to actually look at it until I get home later tonight - about 8 hours from now.

 

[justineld]

here it is and don't worry - I am patient AND I appreciate your bothering. OH...be gentle with me...I have an IT dept here that thinks Access sucks and that anyone who isn't "formally" trained should be shot and then killed again!