Time Card Help

[Kicker3]

I'm a newbe to FM. I need your help Please. I have 3 employee's 2 work part time through the winter plowing snow, all 3 work full time in the summer. Here is my questions:

1. I tweeked this time card solution but I need to track hours worked for each Employee ID seperate. ( I bank thier hours until they have 40) so it will span over a few weeks. Then I want to print out their report to send to my accountant.

2. I need to make a report of just the weeks that they haven't been paid for. (not all hours in the database) thats how it works now. Everything you put in will show up in the list view, which will be too much over time.

Can someone give me advice on how to do this?

I have attached a file.

Thank you for being so helpful here in this forum

TimeCards.zip

[LiveOak]

In any timecard solutions I would avoid repeating fields. They make reporting almost impossible. I would use two basic files. Employees and Timelog. The key is to store time in the smallest increments you would ever need to report on. For instance a timelog entry might be an employeeID/projectID/date/start time/end time. If you make a timelog record the smallest atom of timecard information you care about, you can always combine entries to summarize by employee, week, project, time periods, whatever.

-bd

[Kicker3]

I dont understand.. Are you saying to make 2 tables?

one Employees & the other Timelog? with a relationship via EmployeeID?

Sorry for not getting this.....

[LiveOak]

That is correct. The records in Timelog can be summarized by week, month, employee, project, or an arbitrary date range.

-bd