truncate last 2 characters

N

Naresh

Hi

how can i truncate last 2 characters using Ms Access97. Is there any
function ?

AH1121SI should be displayed like AH1121
DW421SH should be displayed like DW421

Thanks in advance

Naresh
 
B

Brian

Naresh said:
Hi

how can i truncate last 2 characters using Ms Access97. Is there any
function ?

AH1121SI should be displayed like AH1121
DW421SH should be displayed like DW421

Thanks in advance

Naresh
Click to expand...

Answered in microsoft.public.access
 
Top