Take the 2-minute tour ×
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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.