[AccessD] Table Export to text - decimals truncate

The example; "0444","COST","011100007","REG","O21",536.00,,0.4375
The first 'field', "0444", is a string specification for an import -
same for 2-5.
Fields 6 and 8, 536.00 and 0.4375 are numbers except the access export
chops the second number to 0.43 in the resulting txt file.

> -----Original Message-----
> From: Charlotte Foust [mailto:cfoust at infostatsystems.com] 
> Sent: Tuesday, May 25, 2004 2:48 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Table Export to text - decimals truncate
> 
> 
> Numbers don't have leading zeroes unless they are formatted 
> as strings. What's the difference between 0444 and 0.4375?
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: Martin Kahelin [mailto:mkahelin at gorskibulk.com] 
> Sent: Tuesday, May 25, 2004 8:31 AM
> To: Accessd
> Subject: RE: [AccessD] Table Export to text - decimals truncate
> 
> 
> That works except it turns the value (last) to a string like this
> 
> "0444","COST","011100007","REG","O21",536.00,,"0.4375"
> 
> I need it as a value 
> "0444","COST","011100007","REG","O21",536.00,,0.4375
> 
> export keeps chopping the the data to 
> "0444","COST","011100007","REG","O21",536.00,,0.43
> 
> -does it in acc97 and acc2002
> 
> > -----Original Message-----
> > From: Gary Kjos [mailto:garykjos at hotmail.com]
> > Sent: Saturday, May 22, 2004 9:23 AM
> > To: accessd at databaseadvisors.com
> > Subject: RE: [AccessD] Table Export to text - decimals truncate
> > 
> > 
> > You could try to format your field in the query with a 
> format function 
> > ala
> > 
> > Outputfield:Format(DataField,"0.0000'"
> > 
> > Gary Kjos
> > garykjos at hotmail.com
> > 
> > 
> > 
> > 
> > 
> > >From: "Martin Kahelin" <mkahelin at gorskibulk.com>
> > >Reply-To: Access Developers discussion and problem
> > >solving<accessd at databaseadvisors.com>
> > >To: <accessd at databaseadvisors.com>
> > >Subject: [AccessD] Table Export to text - decimals truncate
> > >Date: Fri, 21 May 2004 15:35:55 -0400
> > >
> > >Hi;
> > >I'm exporting a query to a comma delimited text file.
> > Numbers with 4
> > >decimal places are truncated to 2 decimal places; 2.3275 
> shows up in 
> > >text file as 2.32.
> > >
> > >I hope this is not a feature and can be fixed.
> > >Martin
> > >
> > >--
> > >_______________________________________________
> > >AccessD mailing list
> > >AccessD at databaseadvisors.com 
> > >http://databaseadvisors.com/mailman/listinfo/accessd
> > >Website: http://www.databaseadvisors.com
> > 
> > 
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>