Help with attached project

[kpj]

As, I have shown in my last posted attached file, I have a place for closing balance.

Closing balance would be opening balance - total debit amount + total credit amount for that particular date.

This closing balance would be opening for the next date.

i.e. say user has enter 01/08/2006 and 24/08/2006 in frmTemp in from and to date respectively.

So, in 01/08/2006 opening balance would be from database i.e. table OPBAL.

Its closing would be calculated based as i showed the formula above

Now, according to my report, next date would be 03/08/2006 that comes between above date.

So, the opening for this date would be closing of 01/08/2006.

How to achieve this in data report ?

[jp140768]

Possibly the easiest way, but not necessarily the best way would be to create a temporary recordset with the values you want displayed, and then run the data report ove the temporary recordset which now contains the correct values.

HTH

[kpj]

Thanks jp140768
I would try using it. I was also thinking to create a temporory table for it and then using it and then deleting that table once a report is generated.

Thanks a lot for your help.