[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
>