I want to create a database, in which I have to maintain Production Plan for the year. The condition is that every 2nd and 4th Saturday & all the Sundays in a month will be Holiday. There can be more holidays in a year for which there will not or should not be any production plan.
Can you please guide me, what should be my table structure?
I have created following tables: 1) tblDays 2)tblMonths 3)tblYears 4)tblHolidays. And by using functions
Expand|Select|Wrap|Line Numbers
- dteDate: DateSerial(tblYears.Year,tblMonths.Month,tblDays.Day)
thanks
regards
Narender Sagar