Need help with a Table

[Joe Cilinceon]

What I have is an Employee file with ID #, name and other personal info. I
wanted to know the best way to track hours worked. Now I don't have to worry
about wages as this is strickly for salaried employees but just for a time
sheet that is hand done now. The pay period runs from Sat to Sun with 2
week pay period. Right now I'm thinking of just having a form put in the
hours worked from and to daily then group them by pay period. Another table
to track the pay periods. Any help or suggestions would be appreaciated.

 

[John Vinson]

What I have is an Employee file with ID #, name and other personal info. I
wanted to know the best way to track hours worked. Now I don't have to worry
about wages as this is strickly for salaried employees but just for a time
sheet that is hand done now. The pay period runs from Sat to Sun with 2
week pay period. Right now I'm thinking of just having a form put in the
hours worked from and to daily then group them by pay period. Another table
to track the pay periods. Any help or suggestions would be appreaciated.

I'd suggest - first - starting with the tables and only then working
on the forms! A typical timecard table setup would be

Employees
ID
LastName
FirstName
<etc>

Timecards
ID << link to Employees
StartTime << date/time with both date and time
EndTime << ditto, lets you cross midnight without messing up


Each session at work would get an entry in Timecards; a simple Totals
query with a criterion selecting all StartTimes within the two-week
range would give you the total hours in that period.

John W. Vinson[MVP]

 

[Joe Cilinceon]

Thanks John that works well for me.

Joe Cilinceon