Paul,
I am using the example above. But when you add 0 to extend the decimal places, it does not provide additional numbers, it adds additional 0. I haven't checked yet but I am wondering if when the query is exported to the .txt file it somehow drops the extra numbers. This is an issue in 2013.
In this particular example, the data is not being used for calculation, so my solution is to make the field a short text and it keeps whatever is put in there.
Thanks for your help.
|