How do I create a Time Sheet in Access to link to invoices?

How do I create a Time Sheet in Access to link to invoices?

Post by YXN0dWJib3 » Sat, 14 Oct 2006 04:30:02


I would like to create a weekly time sheet in Access. This would in turn
link to my invoices so that I can bill clients faster and more efficiently.
Currently, employees enter their time on an Excel spreadsheet - I take this
information and load it into another spreadsheet and then again onto my
invoices. As you can imagine, it's a long and tedious process. I haven't
used Access in a long time, so I'm quite rusty. Any hints would be much
appreciated (especially when putting in days and dates worked!) Trish
 
 
 

How do I create a Time Sheet in Access to link to invoices?

Post by bXNjZXJ0aW » Sat, 14 Oct 2006 08:05:01

'Timesheet' means different things to different people, you will have to be
more specific.
Someone has probably already written one so that would be the first thing to
research. There is no point in re-inventing the wheel.

You will need at least a couple of tables, something like
TASKS:
TaskId
CustomerId
TaskDescription

TIMEENTRIES:
Person
TaskId - relates to Task table
Date
FromTime
ToTime

Dorian