I am exporting to a piped delimited ascii text file. When I view the output in Notepad I find that the field named "value" is consistently limiting the placement of values to the roght of the decimal to two placement values. Things I have done so far are:
1. Tried various number formats for the "value" field in the database table.
2. Used a formatted export query in an export macro
3. Manually exported the data from the table to a delimited text file
When I don't declare an export specification on my export macro my formatted export query works. Any suggestions would be greatly appreciated. Thanks!
1. Tried various number formats for the "value" field in the database table.
2. Used a formatted export query in an export macro
3. Manually exported the data from the table to a delimited text file
When I don't declare an export specification on my export macro my formatted export query works. Any suggestions would be greatly appreciated. Thanks!