AnsweredAssumed Answered

calculate number of days of absence for employee in the month

Question asked by aboblal80 on Feb 23, 2016
Latest reply on Feb 24, 2016 by 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

Attachments

Outcomes