Query to add only weekdays to date(11/01/05 + 5 = 11/08/05)

[kpdenom]

Trying to add a date interval to current date without including weekends. How
can I exclude weekends in expression?

 

[Douglas J. Steele]

I showed some techniques to do this in my September, 2004 "Access Answers"
column in Pinnacle Publication's "Smart Access"

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

There are also a couple of other techniques in the Date/Time section of "The
Access Web" http://www.mvps.org/access/