How can I use NETWORKDAY in Access 2003?

[Guest]

I am trying to find a way to use a fuction like Excels NETWORKDAY in an
Access 2003 table or form. DateDiff won't work for my application.

Any ideas?

Jeff

 

[Douglas J. Steele]

While it is possible to use Excel functions from Access, it introduces a lot
of overhead that, at least in this case, isn't required.

Take a look in the Date/Time section of "The Access Web"
http://www.mvps.org/access/ : there are a couple of different solutions
there.

Alternatively, take a look at my September, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access". You can download the column (and
accompanying sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html