By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,163 Members | 905 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,163 IT Pros & Developers. It's quick & easy.

Parsing E-mail Address

P: n/a
I have a table that with a field of e-mail addresses. I want to create
a query that groups data based on the DOMAIN in each e-mail address.
How do I split the e-mail address field into two parts in the query?

For example, if my table were:

EMAIL SEARCHES
jo*@xcorp.com 5
bi**@yin.com 10
to*@xcorp.com 1
ph**@yin.com 100
to*@yin.com 15

My query results would be...

GROUP BY DOMAIN SUM OF SEARCHES
xcorp.com 6
yin.com 125

Thanks!

Aug 6 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
DanCole42 wrote:
I have a table that with a field of e-mail addresses. I want to create
a query that groups data based on the DOMAIN in each e-mail address.
How do I split the e-mail address field into two parts in the query?

For example, if my table were:

EMAIL SEARCHES
jo*@xcorp.com 5
bi**@yin.com 10
to*@xcorp.com 1
ph**@yin.com 100
to*@yin.com 15

My query results would be...

GROUP BY DOMAIN SUM OF SEARCHES
xcorp.com 6
yin.com 125

Thanks!
Create a column like this in the querybuilder.
Domain : Mid([email],Instr([email],"@")+1)
Then create a totals query on Domain.
Aug 6 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.