Number of Work days

[Manuel Banuelos]

I have 2 date fields: dateIn & dateOut.
Can some one please show me how to get the total of "Work Days" (not including Sat. nor Sun.) to do so?

 

[M.L. Sco Scofield]

Take a look at the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210562 for one
approach. Be aware, as the article states, it does *not* account for
holidays.

The article at http://www.mvps.org/access/datetime/date0006.htm shows both a
non-holiday and a holiday version.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


I have 2 date fields: dateIn & dateOut.
Can some one please show me how to get the total of "Work Days" (not
including Sat. nor Sun.) to do so?

 

[Manuel Banuelos]

You are the greatest, this article helps a lot, maybe I will consider
Denver, been there its beautiful, love the airport.

 

[M.L. Sco Scofield]

See! This is just a *tiny* fraction of the great stuff you will learn!

Beautiful place it is.

However, I'm not sure I share you enthusiasm for the airport.

In the mean time, pick up a copy of "Beginning Access 2002 VBA" (The 2003
version won't be out for a few months.) from Wrox.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com