D
David Widener
When exporting data from a table I cant keep the leading zeros, can anyone help
A
Albert D.Kallal
Just base the export on a query. That way, you can format a column as you
wish.
So, build a quiery. Lets say we got a number field called InvoiceNum.
Just create a field in the query builder like:
MyInvoiceNum
format([InvoiceNum],"00000000")
The above would thus export 8 zeros...padded....
wish.
So, build a quiery. Lets say we got a number field called InvoiceNum.
Just create a field in the query builder like:
MyInvoiceNum
format([InvoiceNum],"00000000")The above would thus export 8 zeros...padded....