Search results for query: *

I would assume it's VBA Tony. It's in access I'm asking about. And the results I'd like to appear on a form or report. Either one. The inputs come from a query I run. Basically what I'm asking it to do is take a sum(total of various imputs from a table) from a query and multiply them by a number...

I have tried a rounding calculation in the control source box of =(5*.025)*100)/100 which will show 12 instead of 13 I also tried =(5*.025)*100+.05)/100 which will show 13 but when an imput of 0 is placed where the 5 is I end up with a .01 which is incorrect as it should be 0. As I know...

Is there any way to do this in Visual Basic? Telling it that an imput of 0 will not require a rounding function? If so can someone walk me through it. I don't know how to write VB. Thanks.

I have tried many ideas given to me. None work. For example. =(5*.025)*100)/100 will show 12 instead of 13 =(5*.025)*100+.05)/100 will show 13 but when an imput of 0 is placed where the 5 is I end up with a .01 which is incorrect as it should be 0. Can anyone please help this poor beginner...

I think my problem is I am trying to add rounded numbers and are really not adding rounded numbers. I am using CCur but though it displays 2 decimal places, more are stored in the field. I have a decimal place of 3 digits and would like it to round to two and then be able to use the two digit...