Hopefully this is the right place to post. Im trying to find out the amount of time between each record.
A little background, I have a table full of entries. Each entry is an activity with a single timestamp and the amount of time it should take. My problem is that each entry only has one timestamp. Assuming the beginning time for each record is the timestamp from the previous record. I'm trying to create a report that will calculate the time between records. This is for output to a report but if I could do it in a query it would be even better.
Hopfully I have explained it enough
Thanks in advance
A little background, I have a table full of entries. Each entry is an activity with a single timestamp and the amount of time it should take. My problem is that each entry only has one timestamp. Assuming the beginning time for each record is the timestamp from the previous record. I'm trying to create a report that will calculate the time between records. This is for output to a report but if I could do it in a query it would be even better.
Hopfully I have explained it enough
Thanks in advance
