Calculating Sum
Posted: Mon May 28, 2012 12:14 pm
I've created the attached report which calculates the amount of paid time for an employee. The records in the Management database will include various records throughout the day. The Group selects the earliest start time and latest end time and rounds them to the appropriate quarter hour. Then depending on the amount of total time between those values, a lunch break time may be deducted. The difference is the amount of Paid Time.
I have all those formulas working in the group headers, but I don't know how to total for the report footer. If I use the same formula, I get errors. Since it's a group, I can't use calculated columns.
Is there a way to set the value of a variable from the value of a text box. For example, I tried to make the AfterPrint action to PaidTime=Text27.
I don't have extensive coding knowledge, so trying to do this in the report interface.
http://dl.dropbox.com/u/2491635/TimeLog%20Report.zip
Thanks,
Tim S.
I have all those formulas working in the group headers, but I don't know how to total for the report footer. If I use the same formula, I get errors. Since it's a group, I can't use calculated columns.
Is there a way to set the value of a variable from the value of a text box. For example, I tried to make the AfterPrint action to PaidTime=Text27.
I don't have extensive coding knowledge, so trying to do this in the report interface.
http://dl.dropbox.com/u/2491635/TimeLog%20Report.zip
Thanks,
Tim S.