C
Code Agent
I want to make a report that shows the total hours and minutes displayed at
the footer. I can calulate the total number of minutes between to 2 times
stored in seperate fields. ex: "Field 1" = 2:00PM, "Field 2" = 3:30PM, "Field
3" = "90". Field 3 is done by doing a DateDiff function in the control source.
I can do a running sum on "Filed 3", but I want it to be formated to display
" 1 Hour & 30 Minutes" in the footer.
I hope this makes sence. Any help would be greatly appreciated. Thanks in
advance!!
the footer. I can calulate the total number of minutes between to 2 times
stored in seperate fields. ex: "Field 1" = 2:00PM, "Field 2" = 3:30PM, "Field
3" = "90". Field 3 is done by doing a DateDiff function in the control source.
I can do a running sum on "Filed 3", but I want it to be formated to display
" 1 Hour & 30 Minutes" in the footer.
I hope this makes sence. Any help would be greatly appreciated. Thanks in
advance!!