I have an access database whereby i import common tasks into a tasks table where they are linked to the current project.
Each task has a start date, end date and due date and a process order number.
What i want to do is create a macro/query/vba?! so that as the tasks are imported the lowest process number gets a start date of today i.e. now () and when that task is closed the next process order number in line gets a start date of the previous process number's end date.
As the common tasks are optional, it could be that the process number increments jump e.g. 1,2,4,5,6,8,10 etc.