Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Exporting to a Pipe Delimited Text File
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...- jewelslee
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
-
Export spec. produced fields with incorrect field lenghts
I will give you all settings from the table, query and macro levels: table: Result column: Value data type: Number field Size:Double format:General Number decimal places:auto default value:0 export query: qryExport2Test (the field of interest is value) SELECT [RESULT].[tag]...- jewelslee
- Post #5
- Forum: Microsoft: Access Tables and Relationships
-
Export spec. produced fields with incorrect field lenghts
Sean, I am having a similar problem. What I have noticed is a decimal value like this .005 is exported to a delimited text file in this format 5e-03 and a table value like this .292 is exported like this .29. I have a formatted export query like this " Format([RESULT].[value],"###.0000") AS...- jewelslee
- Post #3
- Forum: Microsoft: Access Tables and Relationships
