so you have a query with two columns for each client, a debit and a credit column. Doesn't that get out of hand pretty quickly? I mean you wouldn't be able to display more than about 5 or 6 clients on a single report if you're sticking to one page widths.
It sounds like you're trying to turn your data into a spreadsheet which sort of defeats the purpose of having a database to start with.
Maybe you can say what the purpose of the output is as well?
I'm assuming in your payment table your transaction table you have something like this:
PK |
CustomerID |
Debit |
Credit |
1 |
1 |
500 |
|
2 |
1 |
4000 |
|
3 |
1 |
|
3000 |
4 |
2 |
20 |
|
5 |
2 |
120 |
|
6 |
2 |
|
40 |
And your final query looks something like this:
Code:
JonesCredit JonesDebit SmithCredit Smith Debit
3000 4500 40 140
but the question is why?