I have a table as follows:
tblCalls with fields
Call duration is like this:
When I do SUM on CallDuration I get 04.05.11 instead of let's say 28:05:11.
Is there a workaround for this?
SELECT Format(Sum(tblCalls.CallDuration),"Long Time") AS Total