>You make a very good point, and if we were dealing with current balances only, I'd agree 100%. But how do I determine from the invoice details what the outstanding balance for 60-90 days old is? That's where my problem is.
>
>Thanks,
>
Michelle,

You can calculate it on the run. Something like this;

SELECT * FROM Invoices, Customers, Payments ;
  WHERE Invoice.CustNo = Customer.CustNo ;
    AND Customer.CustNo = <The Customer you want> ;
    AND Invoice.AmountDue > 0 ;
 GROUP BY Invoice.InvDate ;
 ORDER BY Invoice.InvDate ;
 INTO CURSOR InvTemp

You now have a cursor with all invoices that have an outstanding balance for the customer you selected. You can SUM() the AmountDue for a date range to get the >90, 90, 60 stuff.