c0dehunter
New member
- Local time
- Yesterday, 23:32
- Joined
- Apr 5, 2009
- Messages
- 3
Hello,
I have a table, where it is recorded when workers sign in to work and sign out. These are two different columns (See attached picture - "Prihod" and "Odhod").
In third column ("Dobropis") I would like access to automatically calculate and save how long worker has been working, when a new record is added to the table.
Now, I know query for this would be
But I don't know where to put this?
I have a table, where it is recorded when workers sign in to work and sign out. These are two different columns (See attached picture - "Prihod" and "Odhod").
In third column ("Dobropis") I would like access to automatically calculate and save how long worker has been working, when a new record is added to the table.
Now, I know query for this would be
Code:
SELECT DATEDIFF("h",[Prihod],[Odhod])
FROM Prihodi_Odhodi;
But I don't know where to put this?
