Group,

I have a question about the Excel Employee Attendance template. It is almost exactly what I need but I'm having trouble getting it to the exact point. Each employee gets different vacation time based upon seniority. I added two fields into tblEmployees, a Year of Hire field and a Total Days Due field. On the main page there are the Key Statistics. I want to see the Total Days Due for that employee, subtract all the days used (except for bereavement), then see that running total. For example: TotalDays Due=10, Days Used = 4, Days Remaining = 6. As days used increases, days remaining decreases.

I am in no way a VBA programmer. I can tackle some basic tasks in Access.

Thanks,
Mark