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]