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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Round function produces wrong answers in Access
Mr.John, the format functions does not work as you specified. I am developing a Payroll Software, and I am using MS Excel to make the time sheet of an employee. My calculation in excel does not match to the calculation in Access. Because (as per above) access round function is rounding to...- ashfaque1
- Post #4
- Forum: Microsoft: Access Other topics
-
Round function produces wrong answers in Access
I have used round function in a DB. but it gives results as follows : function returns round(1.5) 2 round(2.5) 2 round(3.5) 4 round(12.5) 12 round(13.5) 14 . . . . I could not...- ashfaque1
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
-
User Defined Fuction In Excel
Open your excel sheet and press Alt+F11 and then insert a module (module1). then write your function e.g. public function monthname(x as integer) as string do case x case 1 monthname = "January" case 2 .... .... .... ...- ashfaque1
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
