One weekly summary record, for multiple records
Multiple entries are made for payments to independent contractors each weekending date. Those payments are submitted weekly for reiumbursement, but as a single "lump sum" for the week, not by individual timesheet. I need to record status of reiumbursement for those payments, but for each week, not for each timesheet. Having trouble figuring it all out.
Tried several things and I'm sure, once again, I'm missing something painfully obvious. Whenever I struggle with the logic and I'm about to go nuts, I know one of you will enlighten me!
I ALREADY HAVE THIS:
Name Weekend Amount
Employee 1 9/25/2011 $525
Employee 2 9/25/2011 $610
Employee 1 10/2/2011 $450
Employee 2 10/2/2011 $725
I ALSO NEED THIS:
Weekend Amount Sent Paid
9/25/2011 $1135 9/26/2011 9/29/2011
10/2/2011 $1170 10/4/2011 10/6/2011