Baptism by fire LOL

  • Thread starter Thread starter Gerald Stanley
  • Start date Start date
G

Gerald Stanley

Try something along the lines of
Left(Right([emailId], InStr([emailId],"@") + 1),
InStr([emailId],".")-1)

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Being new to it all, I should be in beginners chat;
Click to expand...
however, I am creating queries and need help getting only a
select portion of a certian field. For example, I would
like to trim out the location (domain) of an email address
field. I also wanted to use the first portion for the user
id and have the formula to cut of the id prior to the
domain (e.g., "EmailID2: IIf([emailid] Is Null,"
",Left([emailid],InStr([emailid],"@")-1))").
So, if the email is (e-mail address removed), Jandoe is
Click to expand...
the email id. Now I want to get "atlanta".
 
Back
Top