P
Pierre
I have three fields ([Intime], [Outtime] and [DailyTotal] in a sub form, all
set as short time format.
The dailytotal field calculates the difference between the out time and the
in time fields. This gives me the time worked for that day or period.
Then I have a field [WeeklyTotal] in the footer of the subform that sums the
dailytotal field.
The problem I am having is the weeklytotal field does not give an accurate
number. I do not know how to get it to show time totaling more than 23:59.
set as short time format.
The dailytotal field calculates the difference between the out time and the
in time fields. This gives me the time worked for that day or period.
Then I have a field [WeeklyTotal] in the footer of the subform that sums the
dailytotal field.
The problem I am having is the weeklytotal field does not give an accurate
number. I do not know how to get it to show time totaling more than 23:59.