Excluding email data

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 , 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.
--
Cloudbuster

On Mon, 28 Dec 2009 16:39:08 -0800, Cloudbuster
.(donotspam) wrote:

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

Put a calculated field in the query:

Domain: Mid([email], InStr([email], "@") + 1

--

John W. Vinson [MVP]

John,

Okay, I'm being picky

Let's use...

eMailDomain: Mid([email], InStr([email], "@") + 1

as *Domain* is a Reserved Word. For a complete list see...
http://allenbrowne.com/Ap****ueBadWord.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"John W. Vinson" wrote in message
...
On Mon, 28 Dec 2009 16:39:08 -0800, Cloudbuster
.(donotspam) wrote:

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

Put a calculated field in the query:

Domain: Mid([email], InStr([email], "@") + 1

--

John W. Vinson [MVP]

On Mon, 28 Dec 2009 21:27:49 -0500, "Gina Whipp"
wrote:

John,

Okay, I'm being picky

Let's use...

eMailDomain: Mid([email], InStr([email], "@") + 1

as *Domain* is a Reserved Word. For a complete list see...
http://allenbrowne.com/Ap****ueBadWord.html

g Thanks Gina... I should have suggested "doemain" (www.doemain.com being a
favorite webcomic, alas now finished.
--

John W. Vinson [MVP]