Using of database to record timing

L

lim_eric

Recently, i working on access to help in the time where the workers report to
work. However, i do not know how to connect the timing to the access
database. For example, when the worker key in his id, the time that he report
can he recorded when verified. anyone has any idea to help???
 
J

Jesse Aviles

When the users logs in the database, you can set the time in a hidden field (StartTime)(if you don't
want your user to see it) or in an unabled field (so the user is able to see it but not modify it).
When the user leaves, he will have to key in his id again and you can record his end time (EndTime).
Then it will be a matter of a substraction of EndTime and StartTime. Be aware that if the midnight
is between StartTime and EndTime, the previous solution wont work.
 
Top