Hnasr created this database for tracking tasks. He has spent an obscene amount of time on it and has done a great job! His form is SLICK and is the real fruit of this project.
What I would like to do is report how long each task has been 'active' in terms of minutes for a specified date range. My question is not a how-to question but rather a question of which 'method' to use in formulating my part 1 question of the project..
Currently, the database records the time/date stamps upon execution each of the following events:
STAMP#1 A time/date stamp is entered upon creation of the record (which 'appears' automatic and not triggered by simply entering the task name). This is erroneously recorded as an 'active' stamp even though the name of the task hasn't yet been entered.
STAMP#2. A time/date stamp is entered for the most recently active task.
STAMP#3. A time/date stamp ie entered for each time any record is made either active or inactive.
I therefore, have basically two (2) concerns with regard to 'reporting' how long each task has been 'active'.
1. Should I keep track or keep a log of the 'duration' each task has been active, or use some calculation to determine that information when it's needed?
2. Since the stamps included in 'active' tasks are noted also for tasks that have not yet become active, either calculating or logging the # of minutes for 'active' time based on data in the tables seems like it might be a difficult thing?
I need the weekly report for # of minutes on each task. How should I approach this?
1. Is there an issue with the new task being recorded as 'active?
2. Should I keep a log?
2. Query or Report based on 'calculation'?
Start Free Trial
