number item

[Anonymous]

hi,

i have feild with number item  -  it could be 5 or 6 or 7 or 8  number.

the 2 left number is the color of the item for any case.

how do write to show the number item without  2 left number ?

exm:

123456 - i need 1234

77556531 - i need 775565

55443 - i need 5544

thanks,

yarin.

[sunny_talwar · Accepted solution]

May be this:

Left(Field, Len(Field)-2)

[Anonymous]

at the last exm:

55443 - i need 554