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
|
|||
|
|||
Criteria for an email address field
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
|
|||
|
|||
Criteria for an email address field
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 |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
Criteria for an email address field
If it is a text field try this --
Like "*[0-9]*" -- Build a little, test a little. "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 |
Thread Tools | |
Display Modes | |
|
|