I have a database with a field in a table used for percentages. The filed name is called Percentage. I set the data type to Number, field size to Single, Format to Fixed and decimal places to four.
I am multiplying a value times Percentage and I don't get the right total. The value is 2,578,364,462 times the percentage of .30. The answer I am getting is 773,509,369. I should be getting 773,509,338. Can you tell me what needs to be changed to get the right total?