Zero Fill Data in Query

[NC Beach Bum]

I have a text field length of 13.
The filed contains data that must be right justified and a zero fill on the
left is suggested. Anyone know the code that should go into the query?

Thanks

 

[George Nicholson]

FieldName: Format(SomeValue,"0000000000000")

HTH,