General discussion

  • Creator
    Topic
  • #2344612

    Calculating Networkdays in Access 2000

    Locked

    by anafiseh ·

    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

All Comments

  • Author
    Replies
    • #3722369

      Calculating Networkdays in Access 2000

      by donq ·

      In reply to Calculating Networkdays in Access 2000

      NumDays = [CloseDate] – [OpenDate]

      Microsoft Access stores the Date/Time Vaiable as a Number.

      There aree many methods available in addition to the above that can be found in on-line Help. (i.e., DiffDate)

    • #3720583

      Calculating Networkdays in Access 2000

      by thallone ·

      In reply to Calculating Networkdays in Access 2000

      The Number of days is as the previous answer indicates, but that would be total days. What you then need to do is to take int(5/7 Numdays) + Numdays mod 7. This will give you the numver of days in whole weeks, and the number of days in the partial week. Now all you need is to figure for holidays(if this matters for you), and there you are.

    • #3717925

      Calculating Networkdays in Access 2000

      by anafiseh ·

      In reply to Calculating Networkdays in Access 2000

      This question was closed by the author

Viewing 2 reply threads