Prev: Notes Field on a report has HTML tags
Next: That would work, but only for the end of each invoice.
From: Chi on 6 May 2010 15:03
Hi,

I would like to make a query that give me a list of the emails address with
number in it?

I tried to use wildcard characters in the query design view, but it always
gives me a blank record.
Ex: I would like pull out the emails like below:

Chotran2(a)carle.com
Knguyen2(a)clinic.com
Sue2nguyen(a)parkland.com


Thanks
Chi
From: John Spencer on 6 May 2010 15:20
Using criteria
Like "*[0-9]*"
against the email field should return all that contain 1 or more number
characters.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Chi wrote:
> Hi,
>
> I would like to make a query that give me a list of the emails address with
> number in it?
>
> I tried to use wildcard characters in the query design view, but it always
> gives me a blank record.
> Ex: I would like pull out the emails like below:
>
> Chotran2(a)carle.com
> Knguyen2(a)clinic.com
> Sue2nguyen(a)parkland.com
>
>
> Thanks
> Chi
From: KARL DEWEY on 6 May 2010 16:01
If it is a text field try this --
Like "*[0-9]*"

--
Build a little, test a little.


"Chi" wrote:

> Hi,
>
> I would like to make a query that give me a list of the emails address with
> number in it?
>
> I tried to use wildcard characters in the query design view, but it always
> gives me a blank record.
> Ex: I would like pull out the emails like below:
>
> Chotran2(a)carle.com
> Knguyen2(a)clinic.com
> Sue2nguyen(a)parkland.com
>
>
> Thanks
> Chi
From: Chi on 6 May 2010 16:21
Hi John and Karl,

Thank you very much! It works great!!

"John Spencer" wrote:

> Using criteria
> Like "*[0-9]*"
> against the email field should return all that contain 1 or more number
> characters.
>
> John Spencer
> Access MVP 2002-2005, 2007-2010
> The Hilltop Institute
> University of Maryland Baltimore County
>
> Chi wrote:
> > Hi,
> >
> > I would like to make a query that give me a list of the emails address with
> > number in it?
> >
> > I tried to use wildcard characters in the query design view, but it always
> > gives me a blank record.
> > Ex: I would like pull out the emails like below:
> >
> > Chotran2(a)carle.com
> > Knguyen2(a)clinic.com
> > Sue2nguyen(a)parkland.com
> >
> >
> > Thanks
> > Chi
> .
>
 | 
Pages: 1
Prev: Notes Field on a report has HTML tags
Next: That would work, but only for the end of each invoice.