Truncate Number

Dan · Nov 10, 2004

I am using Access 2002 and have a 13 digit number I want to break out digits
7 - 10. The table is to big to send to excel and do it there. How do I do
this?

Tom Lake · Nov 10, 2004

Dan said:
I am using Access 2002 and have a 13 digit number I want to break out
digits
7 - 10. The table is to big to send to excel and do it there. How do I do
this?

Val(Mid(Str(yournumber), 8, 4))

Tom Lake