Calculating working days based on Date Range

[sohailcdc]

i have question, I am trying to learn Access during my free time Here is my question, i am trying to calculate the working days Based on all web searches I am unable to find the specific scenario I am working in Auto industry, which means auto industry usually close twice a year for any reasons, let say in July for one or sometime two weeks and in December depends upon the Christmas date usually from December 20 till Jan 01

Now my question is when i am enter the holiday details in table do I have to enter line by line date e.g. july 01, 02, 03 (I am able to understand, how this works but still not yet tried) OR july 01 to July 07 (which make sense, but unable to find how to use date range to calculate working days)

any help along with example will be appreciate

 

[namliam]

Have a look here: http://www.access-programmers.co.uk/forums/showthread.php?t=238821&highlight=Holiday

Try and start from there, it needs a slight fix, but we will get to that later.