how to hold record with time and go back to it later.

Hello All,

I am preparing a database to track the daily activities of my team. This is a real time database wherein the users will add their daily ongoing task and submit.

The action for me is, I need to capture the time required for each task.

Also, there is a possibility that the user will have to hold a task for a while/days due to some issue and will start another task. Once they have a feedback on the issue they will resume the pending/holded task.

Here, I need to capture only the time they have invested in performing the task and ignore the time spent to receive feedback on the issue. Hence the time should start when they start the activity and pause when they hold the activity. Again, the time should continue where they had paused, when they re-start the holded activvity and finally ends when the submit.

I have tried several ways, but unfortunately could not able to do it.

Needed your help in this case and any suggestion from your side is welcome.

I have attached my file so that you will get an idea of my database.

Thank you very much.

duplicate post here

http://www.accessforums.net/access/hold-records-along-time-start-again-once-51848.html

kets0985 - Please read this link

http://www.excelguru.ca/content.php?184

kets0985 said:

...
I have tried several ways, but unfortunately could not able to do it.
...

Click to expand...

Which part you are struggling with?
Could you explain what data your tables should hold and when. For me it looks like Ad_Hoc and Routine is more less the same, so why do you have them, why not only one table?
And could you give a brief introduction how your database works?
You know your database we don't, so when you open it and the first thing you encounter is a field in which you've to enter something you have no idea what it should be, and next tab does not show anything, well ... then most people probably closes the database ...

I am preparing a database which will be use to track daily user's activity. Suppose they have started a particular activity then they will select the activity in Routine form and once they complete that they will submit along with the counts.

The different between Routine and Adhoc is, there are pre-define activities in Routine which the users need to select from dropdown and adhoc can be anything hence they would need to define name for that activity by themselves and enter that activity.

I am struggling on the part where the user should be able to hold an ongoing activity and move to another activity. The action will be like this start (Start time) then select hold and submit(end time). Again go the activity kept on hold, so start (start time) and select completed and submit (End time). Now the total time required to complete the activity should show Start time to Hold (End time ) + again (Start time) to completed (End time).

Also they should be able to select on the activity kept on hold, in a table to query may be, by clicking on the button.

Hope this information helps.

Please let me know if require more information on this.

If this is your entire database so I think unfortunately you have started it wrong.
As I see it, a task (activity/project) is the driving part, so it must be the main table.
Linked to the above table you need to have a table where the employee records which task he's on and when it is started / ended.
Whether it is a Routine or Adhoc is no difference, it is registered into the same table.