Find more than 1 @ in email

  • Thread starter Thread starter Song Su
  • Start date Start date
S

Song Su

(e-mail address removed)@gmail.com

How to use query to find email address field that contain more than 1 @ sign
like one above?

Thanks.
 
Use criteria like the following against the email address field.

LIKE "*@*@*"

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Song said:
How to use query to find email address field that contain more than 1 @ sign
like one above?
Click to expand...

Set the criteria for the email address to:

Like "*[@]*[@]*"

You may not need the [ ]s in there.
 
(e-mail address removed)@gmail.com

How to use query to find email address field that contain more than 1 @ sign
like one above?

Thanks.
Click to expand...

CountOccurrances: (Len([FieldName])-Len(Replace([FieldName],"@","")))
 
Back
Top