Mostly we use BI from a repository to compare data between subscribing systems. Access is used for quick looks and to review cross table links on an adhoc basis.
I know it is from the Weekdays Error in the code. I think if I make the date/time just date and forgo the timestamp it may resolve this particular error.
I am attempting to determine workdays in a process. I can successfully do total days, but need to take out the weekends/holidays.
I've created 2 modules
The first is: Weekdays
[CODE]
Option Compare Database
Option Explicit
Public Function Weekdays(ByRef Process_Start_Datetime As Date, _...
I'm an old school nerd. I'm new to Access VB Modules. Have been using Access successfully for years. I am more of a data quality analyst. My first database introduction was Dbase I.