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
... View more