Exporting numeric numbers with leading zeroes

  • Thread starter Thread starter David
  • Start date Start date
D

David

I need to export to a text file a table that contains numeric fields that are
12 position decimals fields. I need to keep the leading zeroes and the
negative signs intact. I am not familiar with VB coding. Any suggestions?
 
Use a query to export your table, and for that field use:
format([SomeField,String(12,"0")) As AliasName
 
Hi -

This suggestion works, but does not allow for decimal places. How many
places do you require after the decimal point? for example, if you need 4
decimal places, use:

format([yourfield],"0000000.0000")
e.g. format(9.06658,"0000000.0000") results in 0000009.0666


John


Use a query to export your table, and for that field use:
format([SomeField,String(12,"0")) As AliasName
I need to export to a text file a table that contains numeric fields that are
12 position decimals fields. I need to keep the leading zeroes and the
negative signs intact. I am not familiar with VB coding. Any suggestions?
Click to expand...
Click to expand...
 
Back
Top