[AccessD] Table Export to text - decimals truncate

Charlotte Foust cfoust at infostatsystems.com
Tue May 25 13:47:45 CDT 2004


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



More information about the AccessD mailing list