Myra-
That is happening because export to text uses "default" formats for fields like this. One way to try to get around it is to write a query on what you want to export, but specifically pre-format the number using the Format function, then export the query.
NumField: Format(DoubleField,"9.000")
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Feb 7, 2014, at 12:31 AM, myrafly@yahoo.com wrote:
When I do an export there is a field with 3 decimal places. When I run it out to a text file. I get 2 of them only. This is not what is wanted or what it used to do when it was an mdb. I suspect a bug, because who would call that a feature? I cannot think of a work around, the result is to be a |" delimited text file. The field USED to be currency, now it is double with 3 decimals. I know it's not working correctly I just want to figure out how to give them what they want. Any suggestions people? I'd love to solve this tomorrow.. (Works fine to excel. by the way....) If I could find a way to write an export from excel that might work. I don't mind extra steps if I have to.
Myra
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar