Truncate

[Dan]

I have a series of number 123456789 How do I truncate to
get 456

 

[Mark]

Try using the mid function in a query mid
([YourField],StartPosition,No. of Charactors)

Mark