how do I use networkdays function in Access queries

[SaintSimon]

In Access 2000, using the function 'NETWORKDAYS' in the field row of a query
I am trying to calculate (in a field called [TimeTaken]) the number of
weekdays it has taken me to complete a task from its [StartDate] to its
[CompletedDate]. Access returns the message "undefined function
'NETWORKDAYS' in expression". I do not know why it is not recognising it?

 

[Van T. Dinh]

NETWORKDAYS is an Excel function, not Access.

For an alternative, see The Access Web article:

http://www.mvps.org/access/datetime/date0006.htm