From: fi.or.jp.de on
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.
From: XPS350 on
On Apr 19, 12:22 pm, "fi.or.jp.de" <fi.or.jp...(a)gmail.com> wrote:
> 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
From: fi.or.jp.de on
that's great

thanks


On Apr 19, 4:18 pm, XPS350 <xps...(a)gmail.com> wrote:
> On Apr 19, 12:22 pm, "fi.or.jp.de" <fi.or.jp...(a)gmail.com> wrote:
>
> > 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,
>
> Peterhttp://access.xps350.com