Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / October 2005

Tip: Looking for answers? Try searching our database.

time sheet management database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rachael - 14 Oct 2005 15:40 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.