month based update query

B

balu

dear friends,
i got an table "employees" every employee will earn (1) 11 casual leave on
1ST of januvary every year (2) 15 special leave on 1st JANUVARY & 1ST OF MAY
IN A YEAR
(3) 20 ORDINARY leaves on 1st of januvary and the casual leave will lapse if
not used before 31st december but special leave can be accumulated up to 300
& 400 ordinary leaves
(A) HOW TO ADD TIMELY LEAVE TO EACH EMLOYEE
(B) BALECE LEAVE IS TOTAL ACCUMULATED LEAVE AND MINUS AVAILED
(C) HOW TO MAKE NULL THE CASUAL LEAVE AFTER 31st DECEMBER
(D) HOW TO PUT LIMIT OF 300 & 400 DAYS IN THE ENTAIRE SIRVICE OF THE EMPLOYEE
IM VERY NEW TO ACCESS KINDLY HELP
BALU
 
Top