Criteria for an email address fied

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

Chi

Sorry, I posted my email at the Report session..

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
 
Sorry, I posted my email at the Report session..

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...

A criterion of

LIKE "*#*"

should return all record containing a digit. Alternatively

LIKE "*[0-9]*"
 
Answered there.

Like "*[0-9]*"

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