Criteria for an email address field

  • Thread starter Thread starter Chi
  • Start date Start date
C

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
 
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 John and Karl,

Thank you very much! It works great!!

John Spencer said:
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
Click to expand...
.
Click to expand...
 
Back
Top