Need Help On Report ( Calcuations ), Access 2007

[shkhaslam]

I have created this tables .. I have data stored in them properly..
What i want is put a combo box in report where i can select account name .. and based on that the ledger of the account should be shown in the way i have attached

in the attachment you will see Bal ( a ) & Bal ( b ) & Total ... I want access to calculate
1) IN ( a ) - OUT ( a ) = Bal ( a )
2) IN ( b ) - OUT ( b ) = Bal ( b )
3) Total = Bal ( a) + Bal ( b ) & in the next row Total = Previous Balance + Bal ( a ) + Bal ( b )

Why cant i post attachments ???

 

[Trevor G]

This forum doesn't allow attachments, you could upload to something like DropBox and then add a link to your thread.

You can't use Combo box on reports, so you would need to use a form and then use the combo as parameters then open the report using the form as part of the query expression.