Remove text from end of word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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
(e-mail address removed)
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...
 
Back
Top