In access database there are two tables. The first is the task dump from the cleansed excel file, and the second is a list of resource names, workstreams, and their emails...
Those two files need to talk so that the resources from the second list will find all tasks in the other data base that they are associated with, create a report, and then send that report off to that specific person with some formatting via email.
(What happens if I have several resources dedicated to one task is that something that will easily be addressed?)
The report needs to list the tasks that each resource must do in the following order. Tasks ending in the next week, Tasks ending between 1 & 2 weeks, Tasks ending between 2 weeks and 1 month.
I think I was not clear.... the tasks mentioned above have to be automated means u have to create a reporting query which will give me report in the desired format automatically.
PS:- READ AND CHECK THE ATTACHED FILE B4 BIDDING