Working Days

[CaribbeanBlue]

Excel has a networkingdays function to calculate the number of working days
between 2 dates....Does Access have such a function?

Thanks.

 

[Douglas J. Steele]

Not built-in, but it's pretty easy to create.

Check http://www.mvps.org/access/datetime/date0006.htm or
http://www.mvps.org/access/datetime/date0012.htm of "The Access Web", or
read 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

 

[CaribbeanBlue]

I'm embarrased to say I know nothing about VBA. I guess I'm out of luck.