I have the following table

Name Date Amount
Anemi Test 31-Dec-11 500
Apnea 1 31-Dec-11 300
NB 1 Panamax 31-Dec-13 275
NB 2 Supramax 15-Nov-11 300
Anemi Test 19 Nov 11 123
Anemi Test 30-Nov-11 200
Anemi Test 31-Dec-11 75

I also have a Starting Date which say in this first instance is 1 Jan 12.
I want to find and SUM the value for each item nearest to the starting date.
In the above the result for Anemi Test would be 375, the SUM for NB 2
Supramax would be 300 and so on. If I were to make the starting date 1 Dec 11
then the result for Anemi Test would be 200 and for NB 2 Supramax would again
be 300.

Thanks in advance/sgl