Hi,

I've got quite a dilemma on my hands.  We use a staff database to monitor
all staff issues.  When it was designed it included a section on Sickness
monitoring.  However this section is based on:

Absence Number (Primary)
Staff Number (Foreign Key)
Leave Date
Return Date
Hours Missed

This structure was perfectly adequate at the time, however the organisations
needs have evolved over the past two years and now we need to be able to
calculate the amount of hours any given absentee has to date.

Currently if a member of staff goes off sick an absence form is completed
and the leave date entered.  When they return we enter a return date and
calculate the hours missed manually.

It is done this way because the related staff table only stores the number
of hours an employee works per week.  It does not record which days.  What I
need to do is run a query to calculate how many hours any current absent
staff member has been away for.

I'm not sure if the structure will support this without including which days
staff work and this would be to much work as they are constantly changing
days.  The only other suggestion I had was to include a field stating how
days these hours are worked over.

Can somebody please either confirm my beliefs or give me some suggestions.

Many thanks

Ian