Rounding function

[boz]

Hello all, I have a query that does a calculation of 15 min increments which
are called units such as: 1 unit=15, 2 units=30, 3 units=45 mins well if the
service is not a full 15 minute increment we can not round up such
as:20min=1.33 units because its not a full 30 minutes to equal 2 units. How
would I put a function in the criteria to round down to 1 if its not the full
15 minute increment?

 

[Michel Walsh]

use Int( ).

As example:

INT( DateDiff("n", date_time1, date_time2) / 15 )


Vanderghast, Access MVP

 

[boz]

THANKS SO MUCH! NOT SURE WHAT THIS FUNCTION MEANS BUT IT WORKS AND i WILL
LOOK INTO TO IT FOR MY OWN UNDERSTANDING!!!!!!!!!

 

[Michel Walsh]

It just drops the decimal part of a floating point number.


? int( 1.01), int(1.999), int( -1.05), fix(-1.05)
1 1 -2 -1



and by 'dropping', it means taking the first integer smaller or equal to the
argument. For negative number, -2 is smaller than -1.05 which is itself
smaller than -1, so

int(-1.05) returns -2.


You can use fix( ), instead of int( ), for negative numbers, if 'dropping'
the decimal part is more like fix that like int, in your application.



Vanderghast, Access MVP