[AccessD] Rounding Problem?

LOL, true.  A floating point number by definition stores values which may not play well with 
decimal.  Currencies are by definition decimal.  The currency data type is used to store numbers in 
a decimal fashion.


There is a down side which is speed.  Floating point numbers are handled in hardware whereas the 
currency data type is handled by a software library.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 10/19/2012 4:50 PM, Gustav Brock wrote:
> Hi Rocky
>
> Yes, as I said, but you wouldn't listen.
>
> The sole purpose of having the Currency data type is to prevent issues like this.
> And it is not an isolated "Asian" issue, so book some time for redesign.
>
> /gustav
>
>
>>>> rockysmolin at bchacc.com 19-10-12 20:47 >>>
> Lambert:
>
> That worked!  Thanks.  Hate to make changes to the back end since I have a
> lot of these databases out there to support.  But since no one up to now
> wanted to see more than 2-3 decimal places in the PO I may not need to
> update everybody.  At least I'll know what to do if the situation comes up.
>
>
> Don't think I'll have the problem in N.A and Europe - this guy's in
> Malaysia.
>
> Thanks
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
> Sent: Friday, October 19, 2012 11:34 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Rounding Problem?
>
> Have you tried making the field in the table Currency?
>
>