I need to input a date into one field and have access show me a
another date (plus 20 days) in another field (which I can do) but
here
is where I need help. I need to exclude Saturdays & Sundays and Bank
Holidays. Can anyone one help please

Take a look in the Date/Time section of "The Access Web" 
http://www.mvps.org/access/ There are a couple of possibilities there. You 
could also take a look at 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

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


<burnspaul@hotmail.co.uk> wrote in message 
news:e7910d48-7fc4-4ed0-8f27-42cb155c53dd@k2g2000hse.googlegroups.com...
>I need to input a date into one field and have access show me a
> another date (plus 20 days) in another field (which I can do) but
> here
> is where I need help. I need to exclude Saturdays & Sundays and Bank
> Holidays. Can anyone one help please