Access Functions

[Nigel]

I wish to calculate the difference between two dates but not to count
weekends and holidays. I know that the Excel function Networkdays will do
this, but is there an Access equivalent?

Thanks

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/datetime/date0012.htm at "The
Access Web", or my September, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/djsteele/SmartAccess.html