Text String Queries

[Guest]

Hello,

Please can you help with a query I am trying to write.

I have a list of email addresses for clients e.g. "(e-mail address removed)", I wish to
create a query that will leave the domain name leaving "name.com".

Any assistance is gratefully received.

Regards,

Bry2k

 

[Guest]

Check VBA help for the functions Instr and Right$.
You can use the first to find the location of "@" in the address, then Right
to return the appropriate no. of characters from the end of the string.

 

[John Vinson]

Hello,

Please can you help with a query I am trying to write.

I have a list of email addresses for clients e.g. "(e-mail address removed)", I wish to
create a query that will leave the domain name leaving "name.com".

SELECT Mid((e-mail address removed)

 

[Guest]

Hello,

Thank you very much for your help.

Merry Christmas.

Regards,

Bry2k