Remove text from end of word

F

flint2004

Hi All,
I have Access 2003. I need to remove the letters RO from the end of a list
of part numbers that are different in length. Example;
VK87456RO
ST652RO
JG87945RO
HG68461357RO

What expression could i use to do this?
Thanks,
flint2004
 
R

Rick Brandt

flint2004 said:
Hi All,
I have Access 2003. I need to remove the letters RO from the end of a list
of part numbers that are different in length. Example;
VK87456RO
ST652RO
JG87945RO
HG68461357RO

What expression could i use to do this?
Thanks,
flint2004
Click to expand...

Left([FieldName], Len([FieldName])-2)
 
F

flint2004

Thanks to you both. I'll give it a try now.

PC Datasheet said:
Left([PartNum],Len([PartNum])-2)


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


flint2004 said:
Hi All,
I have Access 2003. I need to remove the letters RO from the end of a list
of part numbers that are different in length. Example;
VK87456RO
ST652RO
JG87945RO
HG68461357RO

What expression could i use to do this?
Thanks,
flint2004
Click to expand...
Click to expand...
 
Top