Calculation is rounding when I don't want it to

[wendell42]

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

 

[Joe4]

Can you change your query to SQL View, and post it here for us to review?

 

[wendell42]

I think I got it Joe4. Not sure what was happening, I was building and updating the table using a macro. I re-created everything and it is working fine now.

Was pretty strange that it was rounding without the ROUND function.

Thanks anyhow.

Wayne

 

[Joe4]

I usually see that when people pick something like Integer or Long for the Data Type (which are whole numbers that do not allow decimals), or they apply a Custom Format to the result, which has 0 decimals.