Criteria for an email address field

[Chi]

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:

(e-mail address removed)
(e-mail address removed)
(e-mail address removed)


Thanks
Chi

 

[John Spencer]

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

 

[KARL DEWEY]

If it is a text field try this --
Like "*[0-9]*"

 

[Chi]

Hi John and Karl,

Thank you very much! It works great!!

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

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:

(e-mail address removed)
(e-mail address removed)
(e-mail address removed)


Thanks
Chi

.