Calculating the difference between two successive records
I wish to introduce a new field that calculates the difference in days between two dates. The table would hold disbursements which are identified by a grant ID and a disbursement number (1st 2nd etc.).
I have seen the excellent example Calculation between 2 records in same table. that talks about how to calculate values within one field but could not figure out how to use the table occurences and sorts in a manner that would actually display the difference between two successive records. From what I have, I get the number of days elapsed since the earliest date as can be seen in the screenshot. I would, however, need the number of days elapsed since each successive disbursement.
I would greatly appreciate your help.