Record calculating

[prose7777]

HI,

how can i take the sum of a previous record and another variable to it . then place the result on another record and repeat the process with the next record

EX. record1+variable=record2
record2+diffrent variable= record 3
ect.....

i am useing Access 2000

 

[dcx693]

If, by chance, your records are all consecutively numbered, then you can do a self-join query. Join the table to itself where [table1].[no]=[table2].[no]-1

That way, you can access a previous record value from the current record.

 

[prose7777]

Can this also be done in a form ?

 

[dcx693]

The form cannot do these types of calculations (though you could display the results on the form by using the query).