Search results

It worked like a charm and I do see how the Round function was applied to the formula so I have learned something in addition to having the problem resolved. Thank you!

Right. I want it to drop the 3rd and 4th decimal values and leave both calculated fields values at 48.99. When I run the query the Curr Due value is $48.9932 when I click in it and $48.99 when I click out of it. Total Due value is $48.9974 when I click in it and $49.00 when I click out of it...

I am not discounting your response I just do not understand it. I a ma beginner with Access having cut my teeth on Paradox DB in 1986, I transitioned to Access when it became available but have never understood SQL or VB languages. I use the programs as they are without many modifications.

It looks like the database may be too large. It is 20mb and the upload window looks to be 2mb limit.

JBB that didn't make any difference either. Since they are calculated fields would any of the fields they are derived from impact this?

Thanks JBB. I tried as you suggested but the numbers still come up with the discrepancy. It is a calculated field that only has a value in it when I run the query or report and they are both set to Field Data Type: Number, Field Size: Single, Format: Currency, Decimal Places: 2.

3rd decimal place rounding of number not desired Hi all and thank you to those that answer questions to help those of us less skilled with Access. I am trying to make two calculated fields come out looking the same in a query. When I hover the mouse cursor over them one has a value 48.9932 and...

Paul, Thank you very much for this information. Your generosity has made my life so much easier.

Hello everyone and thank you for your time in making this forum possible. Can anyone tell me how to prevent a negative number from returning when I multiply a field by .06? I created my own billing system and am having trouble with the late fee calculation. If someone has a late payment or...