I have a little problem that I have no idea how to solve. Have a column defined in Access database called Discount Amount. <p>Following is a description of how this column is defined: <BR>
Data Type = Number <BR>
Field Size = Double <BR>
Format = Standard <BR>
Decimals = 2 <p>Actually each cell contains a value that 5 decimal positions but really is showing 2 using rounding. <p>When I export this column to a text file does not bring all decimal positions. It only brings two decimals positions. That is causing me differences in the amount (rounding) <p>For example: <BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value stored Value Display Value Exported <BR>
Discount Amt 646.57747 646.58 646.57 <p>Is there a way that it will be consitent, showing the same number with same decimal positions? All 5 decimal positions <p>Thanks! <BR>
Mayra Camejo

mayra camejo wrote:<BR>
> Actually each cell contains a value that 5 decimal positions but<BR>
> really is showing 2 using rounding.<BR>
><BR>
> When I export this column to a text file does not bring all decimal<BR>
> positions. It only brings two decimals positions. That is causing me<BR>
> differences in the amount (rounding)<BR>
><BR>
> For example:<BR>
> Value stored Value Display Value Exported<BR>
> Discount Amt 646.57747 646.58 646.57<BR>
><BR>
> Is there a way that it will be consitent, showing the same number<BR>
> with same decimal positions? All 5 decimal positions<BR>
<P>
Mayra,<BR>
<P>
Can you possibly use an intermediate field to hold the rounded value, then<BR>
export this new field instead of the original?<BR>
<P>
Bill<BR>
<P>
<P>