Help with two lines adding

[jmagness]

Hi all,

I am looking for with adding two lines in a table.

In a form/Table I have several numbers (Example below)

Index Amount #1 Difference
------- --------- ----------
1 $3.00 $0.00
2 $4.00 $1.00
3 $6.00 $2.00

What I need help with is the process in Access to have
the system calculate the Difference field

The difference is gotten by taking Index#2 from Index #1,
etc....

The problem is getting the number from the previous line
to use in the present line.

Any help would be great,

Thank you in advance,

Jay

 

[Hedi]

Try using the DLookUp() function.

Set the Difference text box control source property to:
"=[Amount #1] - DLookup("[Amount #1]","[Your table
name]","Index=" & Index-1)"

Make sure your form is ordered by Index.

Hope this helps
Hedi