General discussion
-
Topic
-
Calculating Networkdays in Access 2000
LockedHi,
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 itThank you
All Comments
Viewing 2 reply threads