Ubnormal SUM behavior

[spleewars]

The scenario is based on 2 data fields: "IN" and "OUT": both are time fields and the main function is to serve as a punch clock. In order to work out calculations and get the total time, both were passed into a query and set out the formula:


datediff ("n",[in],[out])

So to convert the raw time of the latter formula, i set a new one to divide the amount of 'datediff' into hours and minutes:


[totalhours]\60 & Format([totalhours] Mod 60, "\:00")

Everything's fine to here... however, when i loaded the query into a continuous form and set the SUM function into an unbound text box (so i could sum up all the totalhours) ERROR pops up. The control scorce of the textbox is:




=SUM([totalhours])\60 & Format(SUM([totalhours]) Mod 60, "\:00")

Obviously the textbox is set in the footer but still resolving the error.


What is the reason of the error?
Clara

[June7]

An error message pops up or just shows in the textbox?

Probably has to do with having Sum in the expression twice. Try doing the Sum calc alone in a textbox. Then refer to that textbox in concatenation calc in another textbox. You can make the Sum textbox not visible.