Ledger report

[yaron]

I want to create a ledger.

I have 2 logical tables.

Checks Due (amount, date) , id, forign key.

Checks Received (amount date) , id, forign key.

both of them have foreign key that represent a deal (where the money should be arriving in several payments)

and I want a ledger to be created.

where the lines are sorted by the date order.

and I would have a total down at the bottom (or even a balance field on the right of the line)

can I do it in a report?

should I combine the "receivables" & the "received" tables into one table? I really dont want to do that.

thanks for your help, I know it is not easy question

but Im sure there should be someone outthere who knows the solution.

Yaron.