N
nvchaz
I am converting a simple Access 97 database that contains two queries with some calculations to Access 2002. The queries calculate interest off a financed amount. There is no code.
I cannot get report results to match between the two versions even though the conversion went without a flaw. I even re-wrote the database in Access 2002 from scratch using the '97 queries and the results will not match. The discrepancy is very small - and I strongly suspect rounding errors. I've tried seemingly everything (increasing decimal point precision, checking all tables, queries for decimal precision, etc.) In the end the two version look identical, but when I run identical data sets through them - no match!!!
Anyone have a clue as to what going on?
I cannot get report results to match between the two versions even though the conversion went without a flaw. I even re-wrote the database in Access 2002 from scratch using the '97 queries and the results will not match. The discrepancy is very small - and I strongly suspect rounding errors. I've tried seemingly everything (increasing decimal point precision, checking all tables, queries for decimal precision, etc.) In the end the two version look identical, but when I run identical data sets through them - no match!!!
Anyone have a clue as to what going on?