Excluding email data

  • Thread starter Thread starter Cloudbuster
  • Start date Start date
C

Cloudbuster

I want to make a query that will show me only parts of the email addresses in
a specific field. So, if I have an email like (e-mail address removed), and I
only want the query to show me "hotmail.com" for that record, how do I do
this? Basically, I ask b/c I am trying to group the different types of email
accounts that our clients have.
 
I want to make a query that will show me only parts of the email addresses in
a specific field. So, if I have an email like (e-mail address removed), and I
only want the query to show me "hotmail.com" for that record, how do I do
this? Basically, I ask b/c I am trying to group the different types of email
accounts that our clients have.
Click to expand...

Put a calculated field in the query:

Domain: Mid((e-mail address removed)
 
Back
Top