Networkdays funtion

[KevinNewtoAccess]

I am trying to use the NETWORKDAYS function to calculate working days between 2 events. Access 2000 is reporting this as an unknown function. I have checked the help on this which advises me to check for a library (MSOWCF.DLL) and to re-install Access if it is missing. This dll is in place on my system so I am confused as to why Access is not recognising this function.

Any suggestions?

 

[DougP]

Functions that use a .DLL must also have a "Declare" statement in a module. This tells Access or VB where to find the function, and in which .DLL on your hard drive.

something like

Public Declare Function NetApiBufferFree Lib "Netapi32.dll" (ByVal lpBuffer As Long) As Long

Note: this is not correct for your's, cause I don't have the MSOWCF.DLL
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive