AnsweredAssumed Answered

One weekly summary record, for multiple records

Question asked by LambdaEnt on Oct 6, 2011
Latest reply on Oct 7, 2011 by LambdaEnt

Title

One weekly summary record, for multiple records

Post

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!

Example:

I ALREADY HAVE THIS:

Timesheets
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:

Payment Status
Weekend     Amount     Sent         Paid
9/25/2011    $1135    9/26/2011  9/29/2011
10/2/2011    $1170    10/4/2011  10/6/2011

Outcomes