Results 1 to 3 of 3
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    business day


    All, does anyone have a calculation for getting the monthly business day based on the date logged in another field by a user? I have two dates on a form and a text box for the business day of the month. For Ex. dtMonth field 1/1/2016 and completeddte field is 1/12/2016 txtbusinessday field auto update to 8. Thanks

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    This has surely already been addressed in your cross post at: http://www.access-programmers.co.uk/...sed+on+the+dat
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    Sorry; This was still sitting on my desktop and I thought I forgot to post. Let me catch up and will post back in the other forum.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-05-2014, 03:44 PM
  2. Build Database for Business
    By aggiemarine07 in forum Access
    Replies: 3
    Last Post: 11-07-2012, 03:50 PM
  3. Business Weekday?
    By HMEpartsmanager in forum Queries
    Replies: 2
    Last Post: 10-01-2012, 01:28 PM
  4. CRITERIA only looks at the LAST 20 BUSINESS DAYS
    By taimysho0 in forum Queries
    Replies: 3
    Last Post: 12-06-2011, 06:27 PM
  5. First week or business day of the month
    By Dutch1956 in forum Programming
    Replies: 12
    Last Post: 09-18-2011, 08:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums