Problems with PERCENT data

[ajm59]

Hi, in my query I am calculating a NET PRICE starting from the GROSS PRICE and the DISCOUNT % (Percent field). The Net Price shows incorrectly an amount which contains several decimals "invented" at the right end. For example, in this moment I have an item with Gross Price = 576,09 and Discount % = 10,00%. The Discount Amount shown by the query is 57,6090049743652 while the correct result should be 57,609. Therefore the Net Price is incorrect as well. Any thoughts about this ? Is there any known problem with the PERCENT fields ?
Thanks and regards. Alberto

 

[Sammy B]

My guess is that some where you have done other calculations to come up with the 576,09 figure. Access, depending on your settings can calculate math to many decimal points but (again depending on your settings) only shows you the last 2 or 3 decimal points. Then, farther down the process you suddenly have a field that is capable of showing all the decimal points and 'Voila' you have what appears to be numbers that have been 'invented'.

Sam

 

[Rich]

How can you have a discount of 10,00%, as a decimal it's .1 which equates to 10%

 

[Sammy B]

Did you not say that the price before the 10% discount was already screwed up?

If so, was there a process before that manipulated this number or was it directly inserted in a field?

 

[ajm59]

Hi Sammy,
the Gross Price is directly keyed in. I prepared a very small example with 1 table and 1 query, whose behaviour is exactly the same I have in my application. May I send it to you by e:mail ?
Thanks. Alberto