Exclude weekend dates from an automatic date calucation

[Guest]

Hi
I am trying to do a schedule where all forecast dates are automatically
entered in a date add query. It works fine but I need to exclude weekend
dates. How can I do this?
Thank you, please help
Kristal

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/datetime/date0012.htm at "The
Access Web", or 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