Find more than 1 @ in email

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

 

[John Spencer]

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

 

[Marshall Barton]

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

Set the criteria for the email address to:

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

You may not need the [ ]s in there.

 

[fredg]

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

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