8 Replies Latest reply on Feb 24, 2016 2:42 AM by aboblal80

    calculate number of days of absence for employee in the month

    aboblal80

      dears,

       

      good day to you.

       

      i have an employee database and i have been asked to do the absence table and connect it to employee.

       

      the employee table is

       

      id

      first

      last

      full name

      apfkid

       

      absence table is

      apID

      emp name

      date

      number of days

      excuse

       

      what i need is how can i calculate how many days the employee is absent during every month.

       

      please your support

       

      i am attaching the file so you can take a look at it