Subtract records in same field

[rhowle]

I am trying to subtract the records in field A to show in field B for each day.

EXAMPLE
field A field B field C
62398 7/17/2007 1:25
62323 7/16/2007 1:28
62214 7/15/2007 1:28
62147 7/14/2007 1:19
is there a formula that will give me this

Result
field A field B field C
62398 75 7/17/2007 1:25
62323 109 7/16/2007 1:28
62214 67 7/15/2007 1:28
62147 7/14/2007 1:19

 

[lbass]

Use a formula:

{table.fieldA}-next({table.fieldA})

-LB

 

[rhowle]

Thanks you that is what I was looking for I love these forums