Creating Button

H

Howard R

I created a table; In one column I have an employee name and in the other I
have the time that they clocked in for work. How can I create a button so
that when I push it, the time automatically shows up in the appropriate cell.
Thank you in advance for any input.
 
T

Tom Wickerath

Hi Howard,

You can store the clock-in and clock-out times in a table, but the elapsed
hours should be calculated on-the-fly instead of stored in a table. You can
create a calculated column in a query to display the result in a 'cell'. Here
are some articles that should be helpful:

On time and how much has elapsed
http://office.microsoft.com/en-us/access/HA011102181033.aspx

Using dates and times in Access
http://office.microsoft.com/en-us/access/HA010546621033.aspx

How to Calculate Daily Hours Based on Clock In/Clock Out Times
http://support.microsoft.com/?id=237958


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Top