I am exporting to a flat file from a query and need to pad zero's
I have tried .VarCarNumber = Nz(rs!Format([CarNumber], "000000"), "") but it says external name not defined.
I am using VarCarNumber As String * 6 when i declare the variables.
Currently with .VarCarNumber = Nz(rs![CarNumber], "") it exports like TCIX6302 TE170403492190R315 - as you can see it is left aligned and has no leading zero.
Any ideas how I can make this work best. When i try to do it in the query it wont allow CarNumber: Format([CarnUmber],"000000"), it says Circular reference caused by alias "CarNumber in query definitions select list.
Thanks