cutting off all but the first two letters

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

On Sat, 10 May 2008 09:37:00 -0700, paul69 wrote:

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

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

NewColumn:Left([FieldName],2)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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

_______________________
Naz,
London


"paul69" wrote:

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