View Single Post
  #1  
Old June 6th, 2010, 03:33 AM posted to microsoft.public.access.queries
Kelly
external usenet poster
 
Posts: 469
Default Sum and DateDiff

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,