Hello everyone
I recently started working with MS Access and found the following problem.
I have 3 tables: X, Y, Z. I need a result of following equations:
X.2 = X.1 + Y.2 - Z.2
X.3 = X.2 + Y.3 - Y.3
X.4 = ....
where:
1,2,3,4 are successive records
returned to my form.
Is there any way to complete that?
It is easy with Excel, but how can I refer to preceding record in Access?
Regards,
I recently started working with MS Access and found the following problem.
I have 3 tables: X, Y, Z. I need a result of following equations:
X.2 = X.1 + Y.2 - Z.2
X.3 = X.2 + Y.3 - Y.3
X.4 = ....
where:
1,2,3,4 are successive records
returned to my form.
Is there any way to complete that?
It is easy with Excel, but how can I refer to preceding record in Access?
Regards,