Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Time Elapsed Work Days (Aaccess 2000)

    I have a query which generates a report for Date () - AuditDate. I need to know how many working days have elapsed instead of calender days.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Time Elapsed Work Days (Aaccess 2000)

    You will find links in <post#=159312>post 159312</post#> to code that computes the number of working days between two dates, with the option to take holidays (like Christmas Day) into account. You can also look at other posts in the thread containing that post.

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Time Elapsed Work Days (Aaccess 2000)

    I had seen these before but as I am somewhat still a novice I don't know where to put them. As you can see my criteria that I am using currently is very simple and used a a field in the query,. Do I create a module?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Time Elapsed Work Days (Aaccess 2000)

    Put the function into a standard module. Then pass AuditDate as the beginning date and Date as the ending date into the function. The return value will be the number of workdays between them.
    Charlotte

  5. #5
    New Lounger
    Join Date
    Dec 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Time Elapsed Work Days (Aaccess 2000)

    Thanks a lot. It worked.

Posting Permissions

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