I'm creating a form that calculates leave for employees. I have created 2 fields, "hours" and "reason". The user will enter there leave hours in the first field, then select a reason ( Sick, Vac, PBl,....).
There are 31 boxes of each, one for each day, then the totals area auto calculated and placed in the total fields for each different type of leave.
I have drop down boxes for the "reason" and have item values specified in binding. I'm using == to the binding number to specify the type of "reason".
I can get the individual fields to total in the final total area, but have been unable to add two "hours" fields together to get a combine total for the two days.
Example: Joe takes off on Monday for 4 hours PBL, then on Tuesday he takes 2 hours PBL. I need both days added together and totaled at the bottom of the page.
George Kaiser