Serach option
in [Queries]
|
From: fi.or.jp.de on 19 Apr 2010 06:22 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 19 Apr 2010 07:18 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 19 Apr 2010 07:22 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
|
Pages: 1 Prev: With Function Next: Remove “www.” from a text string result in Access ExpressionBuild |