G
Guest
Some help please. I have a query that subtracts date/time (b) from
date/time(a), let's say that the result (formatted hh:nn:ss) is (c). I then
created a report and for summary options I chose Min, Max, Avg (of c).
Reviewing the report for the last couple of days everything was looking fine
.... until today the query results is as follows:-
date/time(a) = 3/20/2006 3:20:05 PM date/time(b) = 3/15/2006 3:05:53 PM
differnce(c) = 00:14:12. The report shows this difference as the MAX
(difference?), when, in reviewing the query, there are differences greater
than 00:14:12. Am I missing something here, any suggestions?
date/time(a), let's say that the result (formatted hh:nn:ss) is (c). I then
created a report and for summary options I chose Min, Max, Avg (of c).
Reviewing the report for the last couple of days everything was looking fine
.... until today the query results is as follows:-
date/time(a) = 3/20/2006 3:20:05 PM date/time(b) = 3/15/2006 3:05:53 PM
differnce(c) = 00:14:12. The report shows this difference as the MAX
(difference?), when, in reviewing the query, there are differences greater
than 00:14:12. Am I missing something here, any suggestions?