Sum and DateDiff
On Sat, 5 Jun 2010 19:33:30 -0700, Kelly
wrote:
Hi,
I doing a calculation in a query of the difference in times. I'm wondering
if I can control the decimal precision to be just (2) places. The number I
end up with is ie; 5.6666666666, can I have this to round off to something
like 5.67?
Here is the query expression I'm using for this;
TotalTime: Sum(DateDiff("n",[StartTime],[EndTime])/60)
Thanks you,
Su
TotalTime: Round(Sum(DateDiff("n",[StartTime],[EndTime])/60),2)
--
John W. Vinson [MVP]
|