I am trying to do a simple calculation where it will take the value in the AssessedVal field and multiply it by a mill rate that I enter. The query works fine, asks me for the mill rate and all. However, it is rounding the results. For example... on one account, the AssessedVal is 10000.00 if I multiply that by the Mill rate of .000786 the result is 7.86, however the calculation is returning a result of 8.00. How can I change this setting to show the exact amount and quit rounding?
Here is the criteria I have for the calculation.
Nz([AssessedVal])*Nz([Enter Mill Rate])
Been fighting with this for hours. Any help would be appreciated.
Wayne
Here is the criteria I have for the calculation.
Nz([AssessedVal])*Nz([Enter Mill Rate])
Been fighting with this for hours. Any help would be appreciated.
Wayne