K krzysiekk Registered User. Local time Today, 13:40 Joined Dec 2, 2009 Messages 74 Feb 22, 2010 #1 Hi I using query in criteria: Like "%VOL%" and working I using: Like "EURO%" and working but when i using: Like "%VOL%" And Like "EURO%" - not working why? its something wrong??
Hi I using query in criteria: Like "%VOL%" and working I using: Like "EURO%" and working but when i using: Like "%VOL%" And Like "EURO%" - not working why? its something wrong??
John Big Booty AWF VIP Local time Tomorrow, 08:40 Joined Aug 29, 2005 Messages 8,243 Feb 23, 2010 #2 I'm not sure if this will work but try; Code: Like "%VOL%" And "EURO%" Last edited: Feb 23, 2010
jdraw Super Moderator Staff member Local time Today, 16:40 Joined Jan 23, 2006 Messages 15,498 Feb 23, 2010 #3 krzysiekk said: Hi I using query in criteria: Like "%VOL%" and working I using: Like "EURO%" and working but when i using: Like "%VOL%" And Like "EURO%" - not working why? its something wrong?? Click to expand... I don't think these criteria will work together. You're asking for something that is like "%VOL%" and "EURO%" at the same time. Can you give us a sample of what you expect to find?
krzysiekk said: Hi I using query in criteria: Like "%VOL%" and working I using: Like "EURO%" and working but when i using: Like "%VOL%" And Like "EURO%" - not working why? its something wrong?? Click to expand... I don't think these criteria will work together. You're asking for something that is like "%VOL%" and "EURO%" at the same time. Can you give us a sample of what you expect to find?
Brianwarnock Retired Local time Today, 21:40 Joined Jun 2, 2003 Messages 12,667 Feb 23, 2010 #4 I wondered if it should have been an OR Like "%VOL%" Or Like "EURO%" Brian