Database Help - Structure

[Losartan]

I created a database to track tardies and absences of my employees. I would like to be able to sum the number of absences and tardies for each person per month and graph it.

Per our attendance policy, 6 tardies = 1 absence. I need to take the total number of tardies that month/6 and add to the total absences that month to equal the total attendance for the month.

I need help. Can you please view my database and give me some ideas?

Thanks,
Jason

 

[Losartan]

Does anybody have any suggestions?

thanks,
Jason