This is a real easy one I assure you!!!

B

BruceM

K

Ken Sheridan

You can't do it by formatting; use a query, using the Instr function to
identify the position of the @ character, and the Mid function to return the
substring to its right, e.g.

SELECT *
FROM YourTable
ORDER BY MID([EmailAddress],INSTR([EmailAddress],"@")+1);

or you can use the Right and InstrRev functions like so:

ORDER BY RIGHT([EmailAddress],INSTRREV([EmailAddress],"@")+1)

Ken Sheridan
Stafford, England
 
J

J.Alladien

Thanks , works great

Please help me with another one , I tried it but it doensnt work,I am not so
skilled!

hardware ([email protected])
melvink ([email protected]
duyker ([email protected])

I would like to display this list as :

hardware
melvink
duyker

Thank in advance





BruceM said:
It's not about formatting the field, but rather parsing the domain from the
e-mail address. Assuming the e-mail field is named , at the top of a
blank column in query design view:

Email_Domain: Mid([Email],InStr([Email],"@")+1)

Move the column to the left of the Email column. Sort both columns
ascending. Use the query as the Record Source for a form or report.

This suggestion assumes each address is in a separate record. If it is
something else, details needed.

[QUOTE="J.Alladien"]
Hi All,

I have a list with e-mailadresses like:

[email protected]
[email protected]
[email protected]
[email protected] ectc

How do I formatt these fields so I can sort them on the last part (on the
msn.com,pep.com) so after sorting it should look like:

[email protected]
[email protected]
[email protected]
[email protected]



Thanks in advance!!!
[/QUOTE]
[/QUOTE]
Click to expand...
 
B

Beetle

Use the following;

Left(,InStr([EMail],"(")-1)
--
_________

Sean Bailey


[QUOTE="J.Alladien"]
Thanks , works great

Please help me with another one , I tried it but it doensnt work,I am not so
skilled!

hardware ([email protected])
melvink ([email protected]
duyker ([email protected])

I would like to display this list as :

hardware
melvink
duyker

Thank in advance





[QUOTE="BruceM"]
It's not about formatting the field, but rather parsing the domain from the
e-mail address. Assuming the e-mail field is named [Email], at the top of a
blank column in query design view:

Email_Domain: Mid([Email],InStr([Email],"@")+1)

Move the column to the left of the Email column. Sort both columns
ascending. Use the query as the Record Source for a form or report.

This suggestion assumes each address is in a separate record. If it is
something else, details needed.

[QUOTE="J.Alladien"]
Hi All,

I have a list with e-mailadresses like:

[email protected]
[email protected]
[email protected]
[email protected] ectc

How do I formatt these fields so I can sort them on the last part (on the
msn.com,pep.com) so after sorting it should look like:

[email protected]
[email protected]
[email protected]
[email protected]



Thanks in advance!!!
[/QUOTE]
[/QUOTE][/QUOTE]
 
J

J.Alladien

Yes,

That did it thanks

Earl

Beetle said:
Use the following;

Left(,InStr([EMail],"(")-1)
--
_________

Sean Bailey


[QUOTE="J.Alladien"]
Thanks , works great

Please help me with another one , I tried it but it doensnt work,I am not so
skilled!

hardware ([email protected])
melvink ([email protected]
duyker ([email protected])

I would like to display this list as :

hardware
melvink
duyker

Thank in advance





[QUOTE="BruceM"]
It's not about formatting the field, but rather parsing the domain from the
e-mail address. Assuming the e-mail field is named [Email], at the top of a
blank column in query design view:

Email_Domain: Mid([Email],InStr([Email],"@")+1)

Move the column to the left of the Email column. Sort both columns
ascending. Use the query as the Record Source for a form or report.

This suggestion assumes each address is in a separate record. If it is
something else, details needed.

Hi All,

I have a list with e-mailadresses like:

[email protected]
[email protected]
[email protected]
[email protected] ectc

How do I formatt these fields so I can sort them on the last part (on the
msn.com,pep.com) so after sorting it should look like:

[email protected]
[email protected]
[email protected]
[email protected]



Thanks in advance!!!
[/QUOTE][/QUOTE][/QUOTE]
Click to expand...
 
Top