Serach option

F

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.
 
X

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.
Click to expand...

Try: like "*AE*"


Groeten,

Peter
http://access.xps350.com
 
Top