Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: GotToBeABetterWay
- Order by date
-
Business Hours - can't quite get it to work
Ah, very clever. It seems I had an extra line of code in there to push to the morning of the next business day those start times that were after business hours. So only the time stamps after 5pm were causing the error. Many thanks! [2thumbsup] Now I just have to figure how out to mark this...- GotToBeABetterWay
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Business Hours - can't quite get it to work
Thanks for the reply. Hmm. Checking... No nulls. All contain a date and time value. (e.g., 7/15/2014 2:46:23 PM)- GotToBeABetterWay
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Business Hours - can't quite get it to work
thread705-1207464 The referenced thread is exactly what I was looking for (calculating business hours between two dates). When I run my query, the calculated hours appear, then I start getting error messages and the values disappear and are replaced with #Error. When I debug, this is what gets...- GotToBeABetterWay
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
