I have a series of number 123456789 How do I truncate to get 456
M Mark May 20, 2004 #2 Try using the mid function in a query mid ([YourField],StartPosition,No. of Charactors) Mark
