Quering Email Address 1

[SpeedStick]

I am trying to develop a query which only pulls the domain name for email address. I want to only display the information between the @ symbol and .com for an email address. What is the best way to do that? I thought by putting this in the criteria section Like "@*", it would work. It does not.

 

[PWise]

 Left(Mid([EmailAddress], InStr([EmailAddress], "@") + 1), InStr(Mid([EmailAddress], InStr([EmailAddress], "@") + 1), ".") - 1)

 

[SpeedStick]

Thank you for your post. I tried to use the code above in a query and I got an error message. "Data type mismatch in criteria expression."

 

[PWise]

this is not to be put in the criteria line!

Put this in the field line

 

[SpeedStick]

Thank you! That did work. I really do appreciate your help in this matter.