rounddown in access queries

L

lay

Is it possible to round DOWN in access? I'm trying to transfer a scorecard
into access from excel, and i need this formula in it...Help?
 
A

Allen Browne

Int() rounds a number down.

Fix() rounds positive values down, and negatives values up (i.e. rounding
towards zero.)
 
L

lay

ok, i thought it worked, but when i compared it to my excel results,it was
different....
 
L

lay

Ignore the previous post please! silly blond me forgot to change one of the
"round" to "int"

Thanks for your help!!
 
Top