Results 1 to 5 of 5
  1. #1
    warpwiz
    Guest

    Working with Workdays

    Access 2k - I am trying to eliminate weekend days when calculating days elapsed. I discovered NETWORKDAYS in Excel. But it's a drag to have to export from an Access query, then work from there (I do my reports in Crystal).

    I can find no reference to doing this within Access. Does anyone know of a way?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Working with Workdays

    Hi: FMS, Inc. has a tool called Total Access Sourcebook which has code for these type problems. The cost is aprox. $150. There is a function to calculate the difference in business days, eliminating Sat, Sun, and Holidays.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Working with Workdays

    Or, check out this <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=39610&page=&view =&sb=&vc=1>post</A>

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

    Re: Working with Workdays

    The cost of SourceBook is much higher than that these days, I'm afraid, and it now contains code for Access/Office/VB.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Working with Workdays

    Check out the VBA functions in the <A target="_blank" HREF=http://www.mvps.org/access/datetime/date0012.htm>Access Web</A>; they have a number of functions for dealing with work days, including one to count the number of workdays between two dates.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

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