Sir,
In my organisation the employee goes on vacations. There actual vacation starts from monday till the completion of date. The previous any holiday(if comes)+saturday+ sunday (counted as previous leave pl) and later holiday(if comes)+saturday+sunday are counted as later (later leave ie ll). I have made few columns in table. First i linked the employee ID,type of leave,pldatefrm,pldateupto,leavefrm,leaveupto,llfr m.llupto, then i count pl (in days)=pldateupto-pldatefrm+1,leave=leaveupto-leavefrm+1,ll=llupto-llfrm total leave =pl+leave+ll
The problem i am getting here is while query if a person goes on monday without previous leave then the pl should shows 0 (zero) but it value is blank. same case is with later leave
I don't want this in form. is it possible to perform such a calculation in sql which take the value ie if plfrm= blank or then the value is equal to one . something like this