Software

Ask something
Discussion Locked

Access question

0 helpful
1 reply

by techie401

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am a helpdesk db. I would like the tasks to get a time stamp when one of the techs takes it off the main list automatically. I have figured out how to automatically time stamp when the task is initally entered but I can not get the time it is taken or finished to automatically time stamp. Any ideas?

1 reply

by lumberjack

I assume you have a "Status" field or the such like

Create a field in you record called "ENDTIME"
Create another called "TIMETAKEN"

On the "Status" field create code under After update option
If STATUS = "closed" then ENDTIME = TIME()
TIMETAKEN= ENDTIME - timestampfield

This discussion is closed to new replies.