[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