Create reports in various Calendar formats within MS Access database.
Following are the details:
(1) The report(s) would use a Query as input. The query contains one concatenated task descriptor and a due date. This due date would be used to add the task to the calendar.
(2) The report(s) would highlight different tasks with different colors depending on value in one particular field.
(3) The report(s) needs to have a Daily View, Weekly View, Monthly View