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
microsoft-access
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