Currency decimal places
Posted on 1998-11-24
I have a VB6 front end and Access 97 backend project where the customer insists on searching for a dollar amount and applying a percentage increase or decrease. If we start out with $20.00 and apply 10% increases all is well but as I test the app and apply numbers like 11.11% to $20.00, Access stores 3 ad 4 significant figures to the right of the decimal point in the table. Then, when the User searched for an amount like $34.47 and the value stored is $34.467, it is never found. How can I ensure that only two decimal values get stored. I am using currency with 2 decimal places.