opening balance in access report

hello,
i am new in ms access
i want opening balance report how to calculate as bank system report
i want this type report

trno date opebal credit debit closing balance
1 01/04/2010 0.00 5000 0.00 5000
2 02/04/2010 5000 1000 100 5900
closing balance 5900

how to calculate this type report

Hi Arvind,
Welcome to this forum!

Create a query which returns the required result.
Create a report based on this query.

The closing balance is the last record in the query?
If so, enter the following property: =dlookup("closing balance","yourquery", "trno = " & dmax("trno","yourquery"))
Which returns the closing balance for the highest trno.

HTH