G
Guest
Please have patience for a true novice here . . . I have read through so many
threads and other suggestions on calculating elapsed time, but still have
some issues. Specifically, I'm using a form to automatically calculate &
store "Time Opened" and "Time Closed" for trouble tickets. (It actually
seems to be working and storing the correct info in the underlying table!)
I created a query to calculate the elapsed time between the two fields in
the table: Time to Resolution: [DTS Activities]![Time Closed]-[DTS
Activities]![Time Opened]. The result displayed is in the following format:
0.0010300. . .
I would also like to calculate an average length of time each trouble
tickets was open. Can I do this in the same query, and, if so, what
expression would I use?
The final question would be how do I store this data in the underlying
table, so I can generate a report from it? Or should I just use the Query to
pull the data from for the report?
Thank you for any assistance you can provide me!!
threads and other suggestions on calculating elapsed time, but still have
some issues. Specifically, I'm using a form to automatically calculate &
store "Time Opened" and "Time Closed" for trouble tickets. (It actually
seems to be working and storing the correct info in the underlying table!)
I created a query to calculate the elapsed time between the two fields in
the table: Time to Resolution: [DTS Activities]![Time Closed]-[DTS
Activities]![Time Opened]. The result displayed is in the following format:
0.0010300. . .
I would also like to calculate an average length of time each trouble
tickets was open. Can I do this in the same query, and, if so, what
expression would I use?
The final question would be how do I store this data in the underlying
table, so I can generate a report from it? Or should I just use the Query to
pull the data from for the report?
Thank you for any assistance you can provide me!!