Calculate Vacation Balance

C

ChrisG

I want to calculate a vacation balanced based on a the following:

For each employee ID
Where Code = "V" or "VX" or "VLX"or "VAX" (Sum hours)
Vacation Bal = Vacation Time - Sum hours

I also want to display on Form and reports.
 
Top