How to extract domain information from e-mail address table?

[Howard Rice]

Access 2000 (9.0.3821 SR-1) / Windows XP Pro

Hi All,

Apologies for the newbie question.

I am trying to use a simple Query to put a list of e-mail addresses in domain name order (ascending alphabetically) but cannot find a way of extracting only the domain information after the @ character in the complete address string. Of course, the addresses in the source table are of different lengths and so the position of the @ character varies.

Any help much appreciated.

TIA

Howard.

[Denburt]

I am currently working on issues with an office upgrade so I am typing this off the cuff so to speak.
Place this in the field name location of the query

In VBA coding window:
debug.print Right("[e-mail]", Len("[e-mail]") - InStr("[e-mail]", "@"))

or in the query...

myDomain:Right(FieldName, Len(FieldName) - InStr(FieldName,"@"))

[Howard Rice]

Thanks very much for such a speedy and helpful response, it worked a treat.

Regards,

Howard.

[Denburt]

Your quite welcome, i'm glad I could help.