I am new to access and was wondering if it could be used to record time spent
on files.
In my job all my "time" must be billable to a "file". It is in 5 minute
increments. I may work on the same file intermintantly throughout the day, 5
to 15 minutes, here and there.
I need something that will total up the total time spent on all files in a
day, as well as the accumulative time over a week, sorta like a spreadsheet
chart.
M T W T F S S
12345-Joe 1:00 0:10 0:45 etc...
12345-Jane
I also need something that will read the chart and take each file
number/name and total all the time spent on that file for a two week period.
It would need to go on a separate sheet something like this:
Date File name/number time spent Signature
Jan 1, 2005 12345-Joe 1:55 JDoe
Jan 2, 2005 12346-Jane etc....
I would like to be able to have a query of some sort so that a box pops up,
I enter the file number, date, and time, and it will put it in the time
sheet. But I also want it to be able to read the file number I enter, and
total the time for that day. So, if I go in twice in one day, I enter the
same file number and day, I want it to ADD the time, not make a new entry.
Is this possible? How hard would it be?
Duane Hookom - 14 Oct 2005 16:53 GMT
When designing tables to store information, disregard how you want the
information to appear in a report. I expect you will need to store your
billable records in a table like:
tblBillableWork
================
BillWrkID
FileID link to primary key of table of files
EmpID link to primary key of table of employees
(I assume you have a record in this table)
WorkMinutes Number of minutes worked on file
You might need to add a field for StartTime if that is significant.

Signature
Duane Hookom
MS Access MVP
--
>I am new to access and was wondering if it could be used to record time
>spent
[quoted text clipped - 31 lines]
>
> Is this possible? How hard would it be?
Ed Warren - 14 Oct 2005 18:32 GMT
You can do what you want with Access, A very easy way is to use the Journal
options in MS Outlook.
Take a look at Journal in the Outlook help file. This will capture the
time, then you can export this to excel and/or access and run a total to get
the hours.
Ed Warren.
>I am new to access and was wondering if it could be used to record time
>spent
[quoted text clipped - 31 lines]
>
> Is this possible? How hard would it be?