The latest revision is at http://www.dropio.com/tasksdb
. I am in need of a better calculation or elimination of unneeded values. The qryCalcActive is supposed to note the time span for each 'period of activity' in a field called ActiveTimes which it does do. The problem is that it also reports other data as active when it really isn't. Hnasr states that Active=False "somewhere?" should fix it. I'm going to look for this next. Much thanks to anyone who can take a look at the database and chime in.