turn 2 digits into 7 digits.

  • Thread starter Thread starter New2Access
  • Start date Start date
N

New2Access

I have a table which a field outputs a text which is a number that
could contain 2 digits up to 9 digits.

i need to only see 7 digits, even if the field contains 2, i need it to
precede with zeros.

any ideas?
 
Back
Top