Project/Item Time Tracking and Reporting

[disneygoof via AccessMonster.com]

Greetings all...

I have created a simple little time tracker database...works well if I am
trackng the entire project. My issue is when I try to track "parts" of the
project. For example; Project A has parts 1, 2, 3, 4, 5, 6, 7 and 8. Let's
say my employee is working on part 3, 4, 5 and 6 at the same time. These
parts, by the way are listed as seperate records in a table/subform. I can
ADD time to each part so let's say each part we start at 2:00 pm (+ seconds)
and end at 3:00 pm (+ seconds). I start time using an afterupdate procedure
and stop time with a checkbox...this works fine. But now I have 4 records
all theoretically showing 1hr each, instead of 1hr total...any thoughts...
sample of the temp table below.

trackid projectid itemid startdate startime
employeeid stopdate stop
10794 221 5494 10/10/09 2:00:15PM 31
3:00:01PM -1
10795 221 5495 10/10/09 2:00:17PM 31
3:00:03PM -1
10796 221 5496 10/10/09 2:00:19PM 31
3:00:05PM -1
10797 221 5497 10/10/09 2:00:23PM 31
3:00:06PM -1

Basically I need to track each ITEMID, but becasue I worked these ITEMID's
together, I need to only account for 1 hour, not 4 hours. when I transfer
this info to my final table and run my report, I show 4 hours total, 1 hour
for each....thoughts?????

Thanks,
David

 

[KARL DEWEY]

I would combine startdate and startime as a single field. You can display
them separate from the one field.
I do not know how you plan on using the time but I think you need to add a
field (Yes/No) Multi-Work or Split_Hours. Then you could calculate prorated
time for each item.
You might have a Hours field to store the time spent. You would need an
update query to put the calculation in it.

We had maintenace software that did time spreading like this. If we did
extra work on one machine and entered a value in the hours field before the
update it left that item out of the calculation.

 

[Compugasm via AccessMonster.com]

Greetings all...

My issue is when I try to track "parts" of the project.

You need to create a table which holds time entries, and uses a combo box to
lookup your part numbers. For example, lets call this new table [tblTask]
which has three fields: [cboTaskPart], [dtmTaskDateBegin], [dtmTaskDateEnd].
The field "cboTaskPart" tells you it is a combo box, from the Task table, to
the Parts table.

For every row in Tasks, select a part number from a combobox. The beginning
date could use the "Now()" default value. The Ending Date, I prefer to make a
command button that enters the "Now()" function when clicked.

This method will allow you to create MANY time entries, because part numbers
are separate from actual time the "task" occurs.

 

[disneygoof via AccessMonster.com]

Karl,

Thanks for the advice. I do have an hours field which I use also, did not
mention that because it works ok. I like the idea of the Muli or Spit box....
had not thought of that. I need to think about how that can work for mw.
The time I an capturing is going to be use for two things: Job Costing and
Payroll, which is why I need the time for the "parts" to show as 1 hr, not 4
hrs. I will ponder your idea and see if I can make it work so it's easy for
the operator.

Agian, Thanks,
David

 

[disneygoof via AccessMonster.com]

Compugasm,

I believe this is basically what I am doing. I habe a seperate table and I
use a combo box (ITEMID) to populate the table (and all the other information
I mentioned). Let me mull this over a little...I guess I am not seeing how
this will allow me have 1 hr total for all parts, versus 1 hr for each part,
totaling to 4 hrs on my report...but let me think about it a little...

Thanks,
David

Greetings all...

My issue is when I try to track "parts" of the project.

You need to create a table which holds time entries, and uses a combo box to
lookup your part numbers. For example, lets call this new table [tblTask]
which has three fields: [cboTaskPart], [dtmTaskDateBegin], [dtmTaskDateEnd].
The field "cboTaskPart" tells you it is a combo box, from the Task table, to
the Parts table.

For every row in Tasks, select a part number from a combobox. The beginning
date could use the "Now()" default value. The Ending Date, I prefer to make a
command button that enters the "Now()" function when clicked.

This method will allow you to create MANY time entries, because part numbers
are separate from actual time the "task" occurs.