I have a table with main records and another related table that are Sub-Records of the main. The sub-records are tasks with start and finish dates for each task. I would like to find the total time to complete the main record by getting the earliest start date and latest finish date for each task and the calculating the difference. what would be the easiest way to do this? I can't find a way to do it via calculated field.
Bookmarks