Selecting the Sum as a subquery worked great.  I always assumed that the 
subquery wouldn't know which ID from the main query you were on and would 
have nothing to compare to in it's where clause.  But I ran it and it 
worked just fine.  Thanks!