Update to exclude weekends and holidays

[Quempel]

I have a table that holds records of checks that will either have todays date or are future dated. There are certain circumstances where a check is also back dated.

What I need to do is make a query that updates the date to the next business day if it happens to fall on a weekend or holiday.

Any help would be very much appreciated.

Thnx
Q

 

[genomon]

Go here :

http://www.mvps.org/access/toc.htm

Check out all the Date & Time code samples!

The Microsoft mascot is a butterfly.
A butterfly is a bug.
Think about it....

 

[MichaelRed]

see also faq181-261 & faq705-3213




MichaelRed