I need to modify an existing query to contain a difficult calculation.
tblAllTasksEachActivation shows the times of each activation of a given task. If the active box is checked in tblAllTasksEachActivation,
then the task has been made active. If the active box there is unchecked, then the same task has been deactivated. This happens any number of times for each task. I need to determine active time for each task based on the values in that table, for each time it they were made active/inactive, and sum those differences. I would prefer to display those sums for each task in the existing qryCalcActiveDuration if possible, and in a separate field named "SumOfActiveTimes" with the results preferably displayed in minutes. That is to say that to obtain the calculation, the following is needed:
1. Determine the difference in time elapsed between each activation and deactivation for each task.
2. Produce a single sum for each task.
3. Place that sum in a new field in qryCalcActiveDuration, and name it SumOfActiveTimes
4. Display the sum's value in terms of minutes.
Database housed here www.dropio.com/tasksdb