Numeric field text output

[jaggar]

I have a field called hours which is numeric (009999.0). When I create a text file, the zeros are removed and the field is left justified. How do I keep the zeros in the text file?

 

[JoyInOK]

Since it is a text file and you presumably won't be using it in calculations again, could you convert it to a string first?
CStr([MyNumericField])

 

[jaggar]

Is their an SQL equivalence to the Visual Basic CStr(Mynumericfield)?

 

[JoyInOK]

If you create your text file from a query, you can use the CStr() function by making it an expression. Instead of pulling MyNumericField down to the grid in Query Design view, put NameAsIWantItToAppearInTheReport: Cstr([MyNumericField]) in the Field row.