Query where field is on the last record

[swarv]

Hi all,

I have a table with fields like: totalmanaged and ID.
Now when the user clicks on the next record I would like a field to calculate the difference between the figure in totalmanaged on the ID before and the value in totalmanaged in the current ID.

Is this possible?

Thanks

Martin

 

[swarv]

Cheers uncle,
I couldn't find his posts.
I so far have this which works for the total:

SELECT Sum(tbldebt.totalmanaged) AS AllTotal, nameid2 as FullName
FROM tbldebt
GROUP BY tbldebt.nameid2;

But I would like to pick this record and then subtract the previous record's amount. The amounts are stored in totalmanaged field.

Is this possible?

Thanks

Martin