Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: sunnydanny
- Content: Threads
- Order by date
-
Rounding in Access 97
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...- sunnydanny
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access 97 Imperfect Rounding Equations
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...- sunnydanny
- Thread
- Replies: 9
- Forum: Microsoft: Access Forms
-
Using Rounded Calculations on Reports
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...- sunnydanny
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
