Tracking Share of Cost (1 Viewer)

[Angelflower]

Hello fellow developers.

I need a query to help me track share of cost for clients. Anyone have any ideas? This is what I am working with. sorry it didn't paste very well. My problem is that my query keeps subtracking the share of cost and I want it to stop subtracking the share of cost once the share of cost has been met. HOpe that makes sense. Thanks in advance for your help in this matter. Angelflower.

BeginDOS EndDOS InvoiceID Processed TotalDays Rate TotalAmount MCostShare AmountPayable
10/1/2006 10/24/2006 5Resid10-06 Yes 24 $47.00 $1,128.00 280.16 $847.84
10/1/2006 10/24/2006 5Resid10-06 Yes 24 $64.70 $1,552.80 280.16 $1,272.64
10/25/2006 10/25/2006 5Resid10-06 Yes 1 $45.29 $45.29 280.16 ($234.87)
10/26/2006 10/31/2006 5Resid10-06 Yes 6 $47.00 $282.00 280.16 $1.84
10/26/2006 10/31/2006 5Resid10-06 Yes 6 $64.70 $388.20 280.16 $108.04

 

[Angelflower]

Still looking for answer

I have attached a sample of two tables and two queires that I am trying to use to come up with some way that I can track share of cost by member per invoice. If anyone has any ideas or suggestions that would be fab! Thanks in advance for your help.