Think I answered this myself in the thread "Return the records that equal the sum" about five pages back. It's about 80% of what I was thinking anyway... ...
Don't know what platform you are using to execute the queries -- I'm assuming it's a centralized platform like dotNet and not a query designer from inside Access.