I built a restitution db. At times we receive checks from institutions that are applied to more than one person. When I run my deposit slip I need to be able to add the dollar amounts applied to separate individuals into one line deposit amount.
If the Payer column and the Check Number column in two separate records match then the Amount column figures need to be added together and shown on the deposit slip. If no Payer column and Check Number columns match other records then the figures for each check needs to be shown on the deposit slip.