Question Taking into account annual working holiday

[Strikertom]

Hello all,

I have had a quick search regarding my question but I cant find something that is what i'm after.

Anyway I am creating a database for my department in access 2010, and we send suppliers non conformances for NG parts, but we require the suppier to reply within 30 days of receipt of email, this due date is recorded when we send the email from the database, that is straight forward setting up the email and report.

But my predicament occurrs when we have our annual summer shut down, xmas shutdown and bank holidays, I want the database to take into account these days and disregard them from the 30 day count reminder.

Does anyone have any thoughts on the best way to do this?
please feel free to comment if you require any more info.

Thanks in advance!
Tom

 

[JHB]

Create a table for containing the dates for summer, xmas shutdown, bank holidays and other holidays like Easter etc.