Serach option

[fi.or.jp.de]

Hi All,

I have 1000 records in access table.
one field has some records like ...
AECH, AUCH, BACH
ESCH, DECH, DKCH
GBCH, FRCH, EUCH
HKCH, HRCH, ISCH
.............................................

I need to run a query where above field contains "AE" or "EU" or "HR"

I tried like "*AE" or Like "*EU"

But i didn't get desired result.

 

[XPS350]

Hi All,

I have 1000 records in access table.
one field has some records like ...
AECH, AUCH, BACH
ESCH, DECH, DKCH
GBCH, FRCH, EUCH
HKCH, HRCH, ISCH
............................................

I need to run a query where above field contains "AE" or "EU" or "HR"

I tried like "*AE" or Like "*EU"

But i didn't get desired result.

Try: like "*AE*"


Groeten,

Peter
http://access.xps350.com

 

[fi.or.jp.de]

that's great

thanks

Try: like "*AE*"

Groeten,

Peterhttp://access.xps350.com