Criteria like

[krzysiekk]

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]

I'm not sure if this will work but try;

Like "%VOL%" And  "EURO%"

 

[jdraw]

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

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]

I wondered if it should have been an OR

Like "%VOL%" Or Like "EURO%"

Brian