I need a way to comb through a large recordset (>1,000,000, fields: member 
id, date, amount1, amount2) and achieve the following:

For every member, determine the date that sum of [amount2] hits or exceeds 
$2000, then start adding up [amount1]. I have spent many hours on this, 
and haven't found a way to do this (other than using VB with Excel, which 
takes a couple of days to run;)

Any insights would be highly appreciated!