Thanks for all three replies - I have now sorted the
problem with your help
-----Original Message-----
Hi

As part of a loan management process I need to calculate
the value of loans outstanding with a specific bank, the
number of loans for that bank and the earliest repayment
date.

Sample data:

Bank Loan Repayment Date
Bank A 1000 01/10/2004
Bank A
Bank A 2000 05/10/2004
Bank A
Bank A
Bank A
Bank A
Bank A
Bank B 1200 01/09/2004
Bank B
Bank B 1000 11/09/2004
Bank B
Bank B 500 15/10/2004
Bank B
Bank B
Bank C 1000 20/10/2004
Bank C
Bank C
Bank C
Bank D 12000 19/10/2004
Bank D
Bank D


Bank Total Loans Count of loans Earliest Repayment
Date
Bank A 3000
Bank B 2700
Bank C 1000
Bank D 12000


I can find the value but am struggling with the count and
earliest repayment (by bank). Can anyone help?


.