Access 2000 Problem

Hello everybody,

I'm trying to develop an accounts program using access 2000 (front and back ends). Almost 70% I have finished. I'm blocked at statements stage. I want to create an account statement (report) which has got opening balance, debit credit and blance.

Example:
Opening Balance/Balance fd. = 100

Debit Credit Balance
100 0 200
0 50 150

Balance+Debit-Credit = Balance

Anybody can help me.

thanks...

Abdulla.

post your table structure and it will be easier for us to determine the best way to do it