Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this:
Left(Field, Len(Field)-2)
at the last exm:
55443 - i need 554