May 6th, 2010, 09:21 PM
posted to microsoft.public.access.reports
|
|
|
Criteria for an email address field
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:
Thanks
Chi
.
|