Truncate Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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

Tom Lake
 
Back
Top