From: Kelly on 5 Jun 2010 22:33 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, From: John W. Vinson on 5 Jun 2010 22:42 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, Sure: TotalTime: Round(Sum(DateDiff("n",[StartTime],[EndTime])/60),2) -- John W. Vinson [MVP] From: Kelly on 5 Jun 2010 23:58 That worked perfect! Thank You "John W. Vinson" wrote: > 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, > > Sure: > > TotalTime: Round(Sum(DateDiff("n",[StartTime],[EndTime])/60),2) > > -- > > John W. Vinson [MVP] > . >  |  Pages: 1 Prev: date and time queryNext: Multiple tables search