cutting off all but the first two letters

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
 
F

fredg

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)
 
N

Naz

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
 
Top