Serach option

  • Thread starter Thread starter fi.or.jp.de
  • Start date Start date
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.
 
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
 
Back
Top