Tracking Sick Time

  • Thread starter Thread starter TM
  • Start date Start date
T

TM

Hi all

I am not new to Access but this problem has me puzzled. I am trying to build
a database that tracks sick time using an employee # as the reference.
I want to track sick occurrences, not days.
1st sick occurrence could be 5 days Jan 1 to Jan 5 for example.
When that employee is sick again, I want to auto number the occurrence 2.

Do you get my drift?

Any info would be appreciated.

TM
 
Hi all

I am not new to Access but this problem has me puzzled. I am trying to build
a database that tracks sick time using an employee # as the reference.
I want to track sick occurrences, not days.
1st sick occurrence could be 5 days Jan 1 to Jan 5 for example.
When that employee is sick again, I want to auto number the occurrence 2.
Click to expand...

I'd suggest a table with fields EmployeeNo (don't use # in fieldnames,
it's a date delimiter), DateOut and DateIn.

Do *NOT* rely on Autonumbers to count records. An autonumber has one
purpose and one purpose only: to provide a unique key. Autonumbers
will be unique within the table, not for each employee, and very well
could have gaps as well. To count occurances, just run a Totals query
against this table.

John W. Vinson[MVP]
 
You need two tables:
TblEmployee
EmployeeID
EmployeeNum
FName
LName
Dept
etc

TblSickOccurrence
SickOccurrenceID
EmployeeID
SickStartDate
SickEndDate

You then need a form/subform. The main form is based on TblEmployee and the
subform is based on TblSickOccurrence.
 
Thanks to both, it makes sense!
PC Datasheet said:
You need two tables:
TblEmployee
EmployeeID
EmployeeNum
FName
LName
Dept
etc

TblSickOccurrence
SickOccurrenceID
EmployeeID
SickStartDate
SickEndDate

You then need a form/subform. The main form is based on TblEmployee and
the
subform is based on TblSickOccurrence.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Click to expand...
 
Back
Top