How do I Match the rounding in Access (query) that was in Excel
Posted on 2011-02-17
I am using a query to create formulas to calculate percentages as well as reimbursement amounts in Access. Calculations were originally done in Excel, but data is stored in Access, so decided to use Access to calculate as well. Unfortunately, Acccess not rounding as in Excel.
For example 42 / 64 =.65625
in Excel displays as .6563 rounding to 4 decimal places,
in Access displays as .6562 rounding to 4 decimal places.
As stated, these must be exact calculations and are finding differences in Access vs. Excel.