I have the following in my query:
Late: IIf([dtmLogTime]>[dtmStartTime],DateDiff("n",[dtmStartTime],[dtmLogTime])\60 & Format(DateDiff("n",[dtmStartTime],[dtmLogTime]) Mod 60,"\:00"),"")
I then list the Late field on my report. Now I have to Sum this field on my report and can not figure out how. The Late field in my query is formatted as medium time. Can anyone help me? Thanks in advance.
Late: IIf([dtmLogTime]>[dtmStartTime],DateDiff("n",[dtmStartTime],[dtmLogTime])\60 & Format(DateDiff("n",[dtmStartTime],[dtmLogTime]) Mod 60,"\:00"),"")
I then list the Late field on my report. Now I have to Sum this field on my report and can not figure out how. The Late field in my query is formatted as medium time. Can anyone help me? Thanks in advance.