How do I round a value to 1 decimal place in a function 3

[Petchy]

I need to run a caluclation based on 1 decimal place and would like to round the value up. What's the best way to do this if at all?

Cheers,

Craig

 

[paron]

If you just want to round to the nearest .x, then try:

(Int([field1]*10)/10)

If you really want to round UP to the nearest .x, then try:

IIf(Int([field1]*10)=[field1]*10,(Int([field1]*10)/10),(Int([field1]*10+1)/10))

Ron

 

[ElGuapo]

Another option just crossed my mind:
iif([field1]<0;fix([field1]);-fix(-[field1]) +1)

ElGuapo