Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: Deduct Weekends and public holidays in Access

    Hi all

    I'm not sure if this has been handled in this forum before, but is there a way of deducting holidays and weekends in a access database? We have a Access database where we would like the weekends and holidays deducted automatically. Any help will be appreciated.

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    subtracting weekedns is doable making use of the relevant date/time functions to decide how many weekends fall between specific dates

    subtracting holidays is trickier unless you define what the holidays are, and they are usually unique.

    usually the best way round this is to store the holidays in a calendar or similar.
    ms access production calendar - Google Search
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2010
    Posts
    601
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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