N
Naveen
I got an error message for the following calculations when
I use 'single' data type.
Qty Price(Single) Qty*Price CorrectResult
1 21.01 21.0100002288818 21.01
2 21.01 42.0200004577637 42.02
3 21.01 63.0300006866455 63.03
But I got the correct result with double data type.I like
to know the reason and the way to fix it.
Further I suggest it is a bug in Access because Excel
gives correct result.
Thank you.
I use 'single' data type.
Qty Price(Single) Qty*Price CorrectResult
1 21.01 21.0100002288818 21.01
2 21.01 42.0200004577637 42.02
3 21.01 63.0300006866455 63.03
But I got the correct result with double data type.I like
to know the reason and the way to fix it.
Further I suggest it is a bug in Access because Excel
gives correct result.
Thank you.