Round down

[Pam]

I have a number with 2 decimal places in a query. I want
to run down to the nearest whole number, even if the
number is 5.99 I want to round down to 5.

 

[Roxie Aho]

-----Original Message-----
I have a number with 2 decimal places in a query. I want
to run down to the nearest whole number, even if the
number is 5.99 I want to round down to 5.
.

Try Fix([UnitPrice]) or Expr1: Int([UnitPrice]). They
work the same for positive numbers. For negative numbers
they operate differently. For -2.3 Fix will return -2
while Int will return -3

Roxie Aho
roxiea at usinternet.com

 

[Rosco]

I have a number with 2 decimal places in a query. I want
to run down to the nearest whole number, even if the
number is 5.99 I want to round down to 5.

Try this:
Expr1: Int([Table_Name]![Field_Name])

Rosco

 

[Pam]

Thank you both this worked great!!!!

-----Original Message-----
"Pam" <[email protected]> wrote in

I have a number with 2 decimal places in a query. I want
to run down to the nearest whole number, even if the
number is 5.99 I want to round down to 5.

Try this:
Expr1: Int([Table_Name]![Field_Name])

Rosco
.