calculate the total time in Report Footage?

[jerry28ph]

i have a problem on how to build an expression to Control Source on to calculate the total time in "hh:mm:ss" format. I tried to make a simple script in Access and it works.

dim tot as date
tot = Format([time1] + [time2] + [time3], "hh:mm:ss")

but this is on Access script, i am having trouble on how to construct the correct expression on the Report Footage (I want to view the summary only of the total time).

Thank you and more power.

Jerry

 

[HiTechCoach]

Ses the replies to you other post on this same subject.

how to add time in access?


If you do not understand something, it is better to reply to your original post that start a new one.