A
Angie Dietz
2 questions:
1)Is there a way in Access to calculate time using a
business calendar so I can eliminate weekends and holiday
hours from the result?
2)I have a form where we capture labor start time and stop
time. I would like to capture the actual labor hours
spent in another field. I would like this field to
automatically populate on the form after the stop time is
entered. I tried attaching a macro to the stop time field
using the datediff function. I get an error which in a
nutshell says I cannot use that function with automation.
Any suggestions?
1)Is there a way in Access to calculate time using a
business calendar so I can eliminate weekends and holiday
hours from the result?
2)I have a form where we capture labor start time and stop
time. I would like to capture the actual labor hours
spent in another field. I would like this field to
automatically populate on the form after the stop time is
entered. I tried attaching a macro to the stop time field
using the datediff function. I get an error which in a
nutshell says I cannot use that function with automation.
Any suggestions?