Hope someone can help.
I am setting up an employee database in Access 2000. Initially I am just interested in holidays.
My sub form (FrmSubHol) has three fields;
Holidays Taken =sum([days taken])
Holidays Acquired =sum([days acquired])
Holidays Left = 25 - [days taken] + [days acquired] ;(Annual leave is 25 days)
These are all unbound text boxes.
My problem (and believe me i've tried all sorts) is how to perform the calculations on a calendar year. The table TblHols contains start date and number of days taken/acqured, initially I would like figures for the current year i.e year(date()) then be able to select different years from maybe a combo box.
Please help as I've got very little hair left.
I am setting up an employee database in Access 2000. Initially I am just interested in holidays.
My sub form (FrmSubHol) has three fields;
Holidays Taken =sum([days taken])
Holidays Acquired =sum([days acquired])
Holidays Left = 25 - [days taken] + [days acquired] ;(Annual leave is 25 days)
These are all unbound text boxes.
My problem (and believe me i've tried all sorts) is how to perform the calculations on a calendar year. The table TblHols contains start date and number of days taken/acqured, initially I would like figures for the current year i.e year(date()) then be able to select different years from maybe a combo box.
Please help as I've got very little hair left.
