Roundup formula use in Access with help round formala

[Sudarshan1]

I am on a elementary level of MS Access skill.
I am trying to create an expression, where I want to round up the value in a field.

Expr1: ROUNDUP(Data![Duration]/60,0)

When executing the qry, I get :
"Undefined function "ROUNDUP" in expression, I am using Access 2000. What am I doing wrong, or Is there another way ?
After that we have use below formula but it not completely correct

IF((Data![Duration]/60)-INT(Data![Duration]/60)<0,(ROUND(Data![Duration]/60,0)+1),(Data![Duration]/60))

Pls help me for correct for below formala

[Stewart Ross]

Hi You are very close to being correct. The function you need is called ROUND, not ROUNDUP, and the IF function in Access is IIF (referred to as an in-line IF):

YourField = ROUND(Data![Duration]/60,0)
IIF((Data![Duration]/60)-INT(Data![Duration]/60)<0,(ROUND(Data![Duration]/60,0)+1),(Data![Duration]/60))

By the way, the INT function does not round up - it just gives you the integer part of a number. Looking at your IIF statement I think it will always take the second branch, as the test you are applying will never result in a negative number. For example, if [Data Duration] / 60 = 1.9, the INT of that value will be 1, and the value tested by the IIF will be 1.9 - 1 = 0.9 which is non-negative, so the second branch of the IIF will be taken.

-Stewart

[Sudarshan1]

Thanks Stewart

We have use below formula in Excel "=roundup(Duration/60,0)"
we want same formula in Access ...But Access not suport "Roundup" Function...Then we have use Round function...
We have use below : "ROUND((Duration/60)+0.49,0)"