Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In Access, I used a query to sum some numbers and appended the answer to another table (table 2). Now I need to export the number as string with five positions, but I can't seem to get it to hard code all five positions.

I have it formatted as text, field length 5, custom format "00000" (I also tried @@@@@). Example: 3 + 3 + 1 = 7. Then append the 7 to table 2. It always shows as 7. How do I make it show as 00007?

share|improve this question

1 Answer 1

In Access, do it as in this query:

SELECT aTable.aNumber, Format([aNumber],"00000") AS yourNumber FROM aTable;
share|improve this answer
worked! Thank you – Wheelersg Jun 21 '11 at 23:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.