Hi,
I have a table that has 4 fields called TblStaffLeave ( PersonnelNo (PK), LeaveType(Int),StartDate (date), EndDate(date)
Example data look like
PersonnelNo, LeaveType,StartDate,EndDate
1234 , 1 , 1/7/2017, 17/7/2017
4353 , 1 , 15/8/2017, 19/9/2017...