Using the Weekday function to show only Workdays in an Access Query ~ DataPig
Channel: LearnAccessByCrystal
Date: 2022-05-24

This video demonstrates how to use the Weekday function with a series of Dates to identify only the workdays (Mon-Fri). It also shows how to include a holiday table to avoid holidays in the workdays result.

This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.