Adding a value from the preceding record

[Derzou]

I would like to add a value from the preceding record to a value in the current record.

This is obviously easy in a speadsheet, but I just wonder how to do it easily in Access ...

Thanks

[hertfordkc]

How are you expecting the set to be ordered? Do the records have a date field?

[RuralGuy]

Not nearly as easy in Access since the concept of "preceding record" is quite relative. What value or field would identify the "preceding record"?

[Derzou]

Yes, the table is sorted by date.
I solved the problem in using two queries.
The first, with records sorted by date in descending order.
And using a second query with a field such as
[Montant]+DLookUp("[Valeur]";"rq T_Epargne";"[Date] <" & "#" & [Date] & "#")

Not as easy as I hoped for, but it's working.

Thanks !

Derzou

[RuralGuy]

That is how it is done in Access or any RDBMS for that matter.