Time Calculations

[Guest]

I've got a query that will show the sum of downtime. The downtime is
measured in minutes, in the queru I'm converting it to hours. The problem is
that the answer is coming out to 10 decimal places, I would like it to be 1
or 2. I've tried changing it in the properties of the field without any
luck. Is there any other way to change this?

Thanks for the help

Tommy

 

[John Spencer]

If you are using the results in a report you can set the format property of
the control to handle the display of the data.

Otherwise, you could try the Round function on the results
Round(1.222456,2) returns 1.22

Or some simple math
Int(1.224456 *100 )/ 100 returns 1.22

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Thanks, that worked

If you are using the results in a report you can set the format property of
the control to handle the display of the data.

Otherwise, you could try the Round function on the results
Round(1.222456,2) returns 1.22

Or some simple math
Int(1.224456 *100 )/ 100 returns 1.22

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..