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

Have 4 email addresses Want to auto forward all in one of them 0
Need help finding old, outdated contacts in Outlook 365 on my PC 0
Extract all attachments from all received Outlook 365 (on my PC) emails to a Folder 1
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Synchronization problems while moving folders to new email 1
More than one data in a field! HELP! 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Macro: VBA code to move/forward email based on subjects and attachments 0

Top