Conditional counting given dates

[Svanton]

Hi,

I have a list of incoming payments, the payments are related to debts. The payer is not necessarily same person who the debt belongs to (i.e. someone else can pay off the debt). I want to count how many debts the person whose debt was paid off had BEFORE and AFTER the payment in question.

So one row could look something like this:

Payment date // Payment amount // Payer // Debtor // Debts before payment // Debts after payment

I've looked in to solving this with a conditional COUNT function (e.g.: COUNT(payment date < loan date) but this doesn't seem to work.

Help would be much appreciated.

BR

[Oligolas]

Post some test data please?

[kiranv_]

posted sample data and expected result from that sample data. Someone will be able to help you .