|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 6th, 2010, 08:33 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Criteria for an email address fied
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: Thanks Chi 
|
|
#2
May 6th, 2010, 08:44 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Criteria for an email address fied
On Thu, 6 May 2010 12:33:00 -0700, Chi wrote:
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: Thanks Chi A criterion of LIKE "*#*" should return all record containing a digit. Alternatively LIKE "*[0-9]*" -- John W. Vinson [MVP]
|
|
#3
May 6th, 2010, 08:44 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Criteria for an email address fied
Answered there.
Like "*[0-9]*" John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Chi wrote: 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: Thanks Chi
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
