General discussion
August 4, 2001 at 06:15 AM
anafiseh

Calculating Networkdays in Access 2000

by anafiseh . Updated 24 years, 11 months ago

Hi,

I have three text box controls, OpenDate, CloseDate, NumDays. The OpenDate,
CloseDate controls are data/time fields and the NumDays is a number field.
Is there a way to use Expression builder to calculate the working days using
the function NETWORKDAYS?

I tried using it in this fashion, Control Source: = NETWORKDAYS (OpenData,
CloseDate) but I get #Name? as a result (I do have the correct dll file
installed for this function, MSOWCF.DLL)

I got to work fine in Excel, but not Access. I did not try doing in VB
because I’m not sure how to start the function. Any help is very much
appreciate it

Thank you

This discussion is locked

All Comments