I have a tricky issue I am hoping an expert can help me with!
On a continuous subform for the 1st record (Order - 1) I need the start date to refer to the main form project date, the end date should be that date + duration.
The next start date (Order - 2) needs to be the above end date + 1. The end date should be that rows start date + duration. Follow that pattern for the rest of the records.
I have attached a DB. qryTasks has the fields with the formulas for StartDate and EndDate.
Below I copied in what I need to arrive at:
(Project start date is 4/17/2014
Order Duration StartDate EndDate
1 5 4/17/2014 4/22/2014
2 10 4/23/2014 5/3/2014
3 3 5/4/2014 5/7/2014
4 6 5/8/2014 5/14/2014