I'm trying to create append a table programmatically using VBA with dates based on some parameters passed by the user. My base table looks as followed.
workDate - workDayName - workDayYearId - departmentID - allowedHours
My objective is to only provide the user with the year of dates the need when they need it making the table smaller and more effificent when used in a query.
The paramenters the user would need to enter is the year and department id. The base table is already linked to two reference tables: workYear table (linked to workDayId) and the department table (linked to department id). Those two fields would just repeat based on the parameters inputed so doesnt need to do anything fancy there. Also the allowedHours defaults to zero so again nothing fancy required there. Just mainly need the dates for the year excluding weekends and the name of the day.
Any assistance would be much appreciated. Thank you.