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...
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...
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
....
....
....
...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.