networkdays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, Have an existing simple criteria in query to find all records between start and end date. I want to exlude weekends and holidays. Can I do this? Can't find help in my Access bible or on the internet. I think I'm just asking the question the wrong way. If I can modify or re-write the criteria, I'd like any help I can get
Thanks
Heather
 
Take a look in the Date/Time section of "The Access Web"
http://www.mvps.org/access/

There are a couple of different approaches shown there.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



heathergr said:
Hi, Have an existing simple criteria in query to find all records between
Click to expand...
start and end date. I want to exlude weekends and holidays. Can I do this?
Can't find help in my Access bible or on the internet. I think I'm just
asking the question the wrong way. If I can modify or re-write the
criteria, I'd like any help I can get.
 
Back
Top