Attendance Database Table Structure

[Losartan]

I would like to build a database to keep track of tardies and absences in my dept (~70 employees).

I need Date, Name, tardy or absent,

My current table:

TblEmployees
EmployeeID PK
Last Name
First Name
Team

TblEvent
EventID PK
Event (Tardy or absent)

TblAttendance
Date
EmployeeID
EventID

Is this a good structure? I need to be able to run a query that will sum the total number of tardies and divide by 6. That number will then be added to the total # of tardies. The query needs to only show the values over the last 6 months.
Any help is appreciated.

Thanks,
jason

 

[Pat Hartman]

Only your column names will be a problem. Do not use embedded spaces or special characters and do not use the names of functions or properties. So - remove the spaces from the first and last name fields and use a name other than Date as the date field in the attendance table and make a two field primary key for this table - AttendanceDate and EmployeeID. To make a two field key (Access supports up to 10 fields in a key or index), select the first field, then use cntl-click to select other fields. When all are highlighted, press the key icon on the tool bar.

 

[Losartan]

Pat,

Thanks for the info. I'm still not getting the result I would like. I need to run a query that will look at the most recent 6 month period and sum the total number of tardies and absences separately. I then need to take the number of tardies and divide by 6 and that value will be added to the total number of absences.

I've attached my database. Can you take a look and help me?
Thanks,
Jason