Help!

[aftershokk]

I have a column with variable length data such as:


Tp190 25 09
ZW5623 23 01
ZX115 11 23 12 456 09

I want to strip off the last two bytes of each record in a quick manner.


Thanks!!!!!

 

[Jon K]

NewField: Left([FieldName], Len([FieldName])-3)
.

 

[aftershokk]

thanks

I have not used access in a year and forget many things.

Thanks!!!!