find number of work days, excluding holidays

D

daddooafloat

I need a way to calculate the number of workdays, minus holidays in an access
database. Excel has the NETWORKDAYS worksheet function, but cannot use it in
access
 
D

daddooafloat

I get a comile error that says user defined type not defined on a line that
says DIM DB as DAO.Database. What is the fix for this? I got this procedure
from the website you directed me to.
 
D

Douglas J. Steele

With any code module open, select Tools | References from the menu bar.
Scroll down through the list of available references until you find
Microsoft DAO 3.6 Object Library and put a checkmark beside it.
 
Top