How is the ActiveForHrs field in qryCalcActiveDuration actually calculated?
I understand that the actual calculation is intended to use both the information in the other two fields (FirstActivation, LastDeactivation) and values from one of the other tables to calculate the ActiveForHrs value.
I need to verify that:
1. I understand the calculation.
2. What is being calculated is what I want to be calculated.
Where / What is this precise calculation?
Database here http://www.dropio.com/tasksdb