I need to Export to text without dropping leading zeros.

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I tried Expr1: Format([ss1],"000000000") in my query, but when I look at my
exported file via NotePad I am still missing leading zeros from SS#. Ron
 
What you have looks ok to me.

You could try:

Format(cstr([ss1]),"000000000"), but I not sure why what you have don't
work....

are you sure your exporting the query, and not accident the table?
 
I looked at something similar I used - Format([myAmt]*100,"000000000") - and
it formatted correctly. It looks like yours should too. But I did have a
problem, still unresolved, when I tried to export the data using a flat file
specification. Access went ahead and applied formatting anyway. I got
around it by not using a specification.

Ron said:
I am exporting from the query.
--
Ron


Albert D. Kallal said:
What you have looks ok to me.

You could try:

Format(cstr([ss1]),"000000000"), but I not sure why what you have don't
work....

are you sure your exporting the query, and not accident the table?
Click to expand...
Click to expand...
 
Back
Top