Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002

    Unanswered: Access 2000 calculations

    I have an eligibility tracker database designed in access 2000. The employees have to process the applications within 10 business days.
    1. How do you determine business days, weekends and holidays?
    2. If I have the following fields: AppStatus, EligDay, EligDate, AppReceived, Reassess etc. AppStatus has a dropdown of (NEW, EAP, REACTIVATE etc.)

    How do I do the following calculations:

    When you select NEW from AppStatus dropdown,
    EligDay = EligDate AppReceived

    When you select REACTIVATE from AppStatus dropdown,
    EligDay = EligDate -Reassess

    Thanks in advance!

  2. #2
    Join Date
    Sep 2002
    South Wales

    Try This

    Dev Ashish has some good date and time comparison functions
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

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