Format text to 5 chars from a number

Posted by Wheelersg on Super User See other posts from Super User or by Wheelersg
Published on 2011-06-21T00:10:18Z Indexed on 2011/06/21 0:24 UTC
Read the original article Hit count: 117

Filed under:

In Access, I used a query to sum some numbers and appended the answer to another table(table2). Now I need to export the number as a text with 5 positions but can't seem to get it to hard code all 5 positions. I have it formatted as text, field length 5, custom foramt "00000" (also tried @@@@@). Example: 3 + 3 + 1 = 7. THen append the 7 to table2. It always shows as 7. I need it to shows as 00007.

© Super User or respective owner

Related posts about microsoft-access