Holidays falling between dates

[Alex Motilal]

Hi everybody
I am developing a database for a cotton trading company. When cotton bales are ready, it is intimated to the contracted buyer. On making payment the buyer lifts the bales. As per the contract the buyer shall lift the bales within 7 days of making payment. However intervening Saturdays, Sundays and National holidays are excluded.
To exclude week ends I am using a module, which I got through this Forum, which works fine.
For National Holidays I have designed a table with fields holidayID, holidayDate and holidayReason. The table is not linked to any other table.


I do want the query to exclude the count of holidays which falls in between the 7 days.
I want somebody to guide me how to accomplish this.
With thanks in advance
Alex

[pbaldy]

It would help to see the module. Typically if it uses the method that loops through dates, you'd include code within the loop to test each date against the holiday table.