Thank you Seth for replying but can you be a little more detailed. I am new to creating db and trying to self teach myself. Any direction is appreciated.

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...