How to calculate time difference between to rows in same column.

[Gaurav]

Hi,
I am working with access on a project and i want to calculate time difference between to rows in same column.
A order comes in system then various department work on and there datetime stamp saved in column for each unique orderid, i have to calculate time difference between two consecutive entry.
not able to use datediff function on different rows.
Please help urgent.
Thank You.

 

[isladogs]

Have a look at the code in this link on my website: http://www.mendipdatasystems.co.uk/getpreviousrecordvalue/4594484854

Also look at the link from there to Allen Browne's website article

NOTE: Time differences can be tricky especially if there is more than 24 hours between them.
Convert each of the date/time values to a double datatype number, subtract them then convert the answer back to hh:nn:ss format