cutting off all but the first two letters

  • Thread starter Thread starter paul69
  • Start date Start date
P

paul69

Hi,

I have Access 2002. I want to create a query so that only the first two
letters of an email appear. How do I create such a query?

Thanks in advance,

Paul
 
Hi,

I have Access 2002. I want to create a query so that only the first two
letters of an email appear. How do I create such a query?

Thanks in advance,

Paul
Click to expand...

Your message is not very clear to someone who cannot see your
computer.
Try something like this:

NewColumn:Left([FieldName],2)
 
Assuming by e-mail you simply mean a field that store someones e-mail address.
All you do is in a query add the table that has the email field and create
an expresion
So instead if dragging a field down from a table simply type in
Twochars:left([Emailfieldname],2)

where emailfieldname is the name of the feild that contains the email.

HTH
 
Back
Top