dmax returning max value under 10 hours

[avacess]

I am trying to use the Dmax function in a query to return the max value for a time field. The expression used is: E1: dmax(“totaltime”,”query1”)
Totaltime is defined as a Dsum expression in the same query. Totaltime output are values are in the short time format (hh:mm).


The result of E1 is showing me the maximum value but up to 9 hours and 59 min (09:59). I have values in Totaltime which are higher than 9:59, up to 35:56 (35 hours and 56 min). But I am not sure why the E1 is not returning values higher that 9:59?
Anyone has any idea?
Thank you all.

 

[jdraw]

Can you show us the SQL for query1?

 

[avacess]

Can you show us the SQL for query1?

jdraw,

sure:
Below I tried to explain how I defined all the fields, expressions, ...

f1, f2, ... - field 1 ...
e1, e2, ... - expresion 1 ...
T1 – table 1
F1 – time format: short time
F2 – time format: short time
F3 – time format: short time
F4 – time format: short time
E2 – time format: short time
e3 – standard
query1 - query

e4 - standard
f5 – autonumber

SELECT [T1].F5, [T1].[F1], [T1].[F2], [T1].[F3], [T1].[F4], (DateDiff("n",[T1]![f3],[T1]![f4],0,0))\60 & Format((DateDiff("n",[T1]![f3],[T1]![f4],0,0)) Mod 60,"\:00") AS [E2], (DSum("[E3]","query1","[f5]<=" & [f5]))\60 & Format((DSum("[E3]","query1","[f5]<=" & [f5])) Mod 60,"\:00") AS TSN, DMax("[f5] ","query1") AS [E4], (DateDiff("n",[f3],[f4],0,0)) AS [E3]
FROM [T1]
GROUP BY [T1].F5, [T1].[F1], [T1].[F2], [T1].[F3], [T1].[F4], (DateDiff("n",[T1]![f3],[T1]![f4],0,0))\60 & Format((DateDiff("n",[T1]![f3],[T1]![f4],0,0)) Mod 60,"\:00"), (DSum("[E3]","query1","[f5]<=" & [f5]))\60 & Format((DSum("[E3]","query1","[f5]<=" & [f5])) Mod 60,"\:00"), DMax("[f5] ","query1"), (DateDiff("n",[f3],[f4],0,0));


I hope it makes sense

thank you for your support