Excluding email data

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

John W. Vinson

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)
 
G

Gina Whipp

John,

Okay, I'm being <picky>

Let's use...

eMailDomain: Mid((e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

More than one data in a field! HELP! 4
Excluding empty fields 4
Join strings in Query 1
Outlook 2010 macro to open email and reply 0
query excluding listings from table 2
Append Query: SQL to add a new record? 7
Concatenate email addresses 3
Exclude data from field, when another field equals a certain numbe 2

Top