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.
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.