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

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.