I need to create a stored procedure and call it from within an Access application to calculate time spent doing a job. User starts a job -- the clock starts ticking -- the user's shift changes and he leaves the job -- next user restarts job and the clock starts ticking again...
I have 4 fields in this table Start Date and Start Time -- and -- End Date and End Time.
I added 2 computed fields to the table:
StartDateTime -- (dateadd(minute,datediff(minute,(-2),[StartTime]),[StartDate]))
EndDateTime -- (dateadd(minute,datediff(minute,(-2),[EndTime]),[EndDate]))
Table Name is JobTime. RunTime is a float field that needs to contain the duration between the two.
I need to call this from within Access.
I'm sort of new to Stored Procedures so any help will be appreciated.