Reducing a string by a set amount of characters

[AJCB]

Hi,

I have Office 2007 and I am trying to get a variable length field:

APETREG050550 or
AFORMFGREG050550

to read:

APETREG050 or
AFORMFGREG050

Basically taking off the last 3 digits?

Is this possible?

Regards
AJ

 

[fredg]

Hi,

I have Office 2007 and I am trying to get a variable length field:

APETREG050550 or
AFORMFGREG050550

to read:

APETREG050 or
AFORMFGREG050

Basically taking off the last 3 digits?

Is this possible?

Regards
AJ

=Left([FieldName],Len([FieldName])-3)

 

[Martin]

AJCB,

Use the Right(string,length).

In your case.

Dim stemp as string

stemp = "APETREG050550"
stemp = Right(stemp,3)

Hope this helps.

 

[AJCB]

Hi.

Thanks for this. It worked just how I wanted it.

AJ

Hi,

I have Office 2007 and I am trying to get a variable length field:

APETREG050550 or
AFORMFGREG050550

to read:

APETREG050 or
AFORMFGREG050

Basically taking off the last 3 digits?

Is this possible?

Regards
AJ

=Left([FieldName],Len([FieldName])-3)

 

[AJCB]

Hi Martin,

If I do this it only shows the last 3 digits, whereas I wanted to take off
the last 3 digits and only show the rest.

Fred's suggestion worked though. Thanks anyway.

AJ