NETWORKDAYS function missing

[Suketu]

When i try to use NETWORKDAYS function in query it gives me an error as
undefined function.

the same function is working with excel.

How can i use this function?

thank you

 

[Douglas J. Steele]

It's not in Access. While you could set a reference to Excel and use the
Excel function, that introduces a lot of overhead.

Take a look in the Date/Time section of "The Access Web"
http://www.mvps.org/access/ for a couple of alternatives, or see 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