Maintaining formats in a query

[flying linus]

I have a table with a three digit number field that I query and concatenate with another field to display an ID. However, the three digit format is lost during the query if there a leading zeros in the number. How can I maintain the three digit format during the concatenation?

 

[Pat Hartman]

You need to use the Format() function in the query.

Select YourFieldA & Format(YourFieldB, "000") As ConcatField