Text String Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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".
Click to expand...

SELECT Mid((e-mail address removed)
 
Back
Top