Results 1 to 3 of 3

Thread: Calculation

  1. #1
    Join Date
    Sep 2002
    Location
    USA
    Posts
    66

    Unanswered: Calculation

    Greetings,
    I have the following fields: AppStatus (with combo boxes New, Redeterm etc.), DateRecieved and DateDue. If New is selected from AppStatus drop down, I want DateDue field to be automatically 10 business days from the date application was received (DateDue= AppRecieved + 9). Can anyone tell me how to achieve this calculation?
    I'm using Access 2K.

    Thanks in advance.
    DD

  2. #2
    Join Date
    Aug 2002
    Posts
    31
    I am not aware of anything in Access that has to do with business days specifically, but you can add a number of weekdays to a date, which may be accurate enough for your purposes:

    DueDat e= DateAdd("w", 10, [AppDate])

  3. #3
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb Working days

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

    Above link to Dev Ashishs "The Access Web" may give you a pointer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •