timesheet for client billing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a time sheet for client billing purposes. I have created a
table to store the following information:
client code, job number, task, staff, date, time

the first three items are pulled from a query of active project. I have a
simple form capturing the data from employees but I would like to create one
that displays and totals a weeks worth of time (subtotaled by day) for each
employee so they can pull it up, review the week, make additions corrections
as needed.

in addition I'd like them to be able to enter the start date and have the
columns automatically increment each day based on the start date.

any suggestions? I can't seem to get all the pieces working together.
 
Have you looked at the Time and Billing template that comes with Access?

The following instructions are for Access 2003. While some details may
differ in earlier versions, to the best of my memory I believe this template
has been around since at least Access 97. If you did not do a complete
install of Microsoft Office, it might be necessary to re-run Office setup
and choose the option to add components.

From the File menu, select 'New'. In the New File task pane, select 'On my
computer ...'. In the Templates dialog box, select the 'Databases' tab.
Finally, select the 'Time and Billing' icon.

Templates are also available on-line at Microsoft's web site. Unfortunately,
some of those on-line templates are buggy. If I remember correctly, I think
the on-line version of the Time and Billing template is one of the buggy
ones.
 
Back
Top