Re: Payroll Strategy
I was going to say exactly the same thing as button moon with regard to payroll in general
however, if you just want to track absence and vacation time, then have a table
employeeid, absencereason, datefrom, dateto, [maybe workingdays]
storing [workingdays] is clearly reduncant, but it may be easier to store the evaluated figure, rather than keep recalculating.
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.