I have a form containing following fields:-
(a) Leave_Code
(b) Service_No
(c) Leave_From (Leave Start Date)
(d) Leave_To (Leave End Date)
(e) No_of_Days
(f) Kind_of_Leave
(g) year_of_Leave
(h)Total_C_Leave
(j) Total_A_Leave
(k) Remarks
Now I want to calculate against a specific person (Service_No) which is already selected, but when I select a year I able to count total number of C_Leave / A-Leave against that year. Any honorable member can help me in this regard
(a) Leave_Code
(b) Service_No
(c) Leave_From (Leave Start Date)
(d) Leave_To (Leave End Date)
(e) No_of_Days
(f) Kind_of_Leave
(g) year_of_Leave
(h)Total_C_Leave
(j) Total_A_Leave
(k) Remarks
Now I want to calculate against a specific person (Service_No) which is already selected, but when I select a year I able to count total number of C_Leave / A-Leave against that year. Any honorable member can help me in this regard