Re : Insert a previous record value into the new record on particular column

Hi All,

I have a issue like this…I have a table of 4 fields…first time you enter the value into the table…

opening reading is 0.000 and close reading…we need to enter… and total usuage will be calculated on close reading - opening reading…

on the next record…the close reading has to be passed as opening reading and new close reading will be entered… and total usuage will be calculated.

how to do this…from a previous record on the same table.

Have a nice day.