This seems simple but I can't figure it out.

I'm pulling back a record set that shows all budgets entered for a company - the main items are EditedBy and Amount. So it might show:

EditedBy Amount
------------------
jsmith 1000.00
kjones 1500.00

So what I need to get is the change amount from one entry to the next to display on the page. Any ideas? Thanks in advance.

Perhaps you can rephrase this so that we can better understand what it is you are requesting.

Woody Z http://www.learntoprogramnow.com

Sorry if I was unclear. I'd like to somehow dynamically pickup the amount the budget has changed with each edit. So after the "Amount" column, I'd like to have a "change amount" column. Using my example, the Change Amount column would show "$500.00" next to the 1500.00 since the budget increased from 1000.00 to 1500.00...

EditedBy Amount ChangeAmt
-----------------------------
jsmith 1000.00 --
kjones 1500.00 $500.00

Okay - so, for each value in Amount, there is a Change Amount, which is the difference between the previous and current amount listed?
This is simple math. One way to do this, is as you loop through the records and create the display output, you must store the previous amount in a variable, do your math to get the change amount and add it to your display output, and then set the variable to the current amount to be used as the previous amount for the next record.



Woody Z http://www.learntoprogramnow.com