Somewhat simplified but if you had a table for employees who are on this payment scheme (or a table for all and a field to define them as a member, or not, of this scheme) and a table for payment records, that ought to give you what you asked for.
tblEmployee |
|
|
EmplID |
Fname |
Lname |
etc. |
1 |
Joe |
Black |
|
2 |
Sam |
White |
|
3 |
Mary |
Brown |
|
|
|
|
|
|
|
|
|
tblEmplPayment |
|
|
EmplPayID |
EmplIDfk |
PayDate |
Amt |
1 |
1 |
9/30/20 |
300 |
2 |
2 |
9/30/20 |
300 |
3 |
3 |
9/30/20 |
320 |
4 |
1 |
10/31/20 |
250 |
5 |
2 |
10/31/20 |
325 |
6 |
3 |
10/31/20 |
300 |
7 |
1 |
11/30/20 |
310 |
8 |
2 |
11/30/20 |
320 |
9 |
3 |
11/30/20 |
330 |
To get summary results, create Totals query, Group By EmplID and summing Amt over a date range.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.