hootie318
Of course its possible!
And not that hard either.
I assume that the numbers in the date columns are hours worked.
I also assume that you want to be able to print out a list of each drivers logged hours.
I would build an entry form with a combo box asigned to the driver table.
(when you pull down this list you can pick a driver)
A text box that holds the date and a text box that holds the hours for that date.
You could modify your date table to hold this info.
Build a report off of this table.
You can make the report sort in what ever fashion you like.
The spreadsheet you have is nice....but limited.
You have much more flexability with a report.
Your form can look how ever you want. You could make it be small and show only one record at a time or you could have it display lots of records at once.
Your report can be set to show only one week at a time, or more.
You could also put totals that add up the drivers hours per week, month and year.
Just some ideas to get you started.
This looks like a fun project, enjoy yourself!
Tom
