Need to match data in two fields against data entered in the same fields and if they

[promotion1]

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.

[Seth Schrock]

Use the Sum() function in a query, with the Payer and Check Number columns in the GROUP BY clause.

[promotion1]

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.

[Seth Schrock]

I recommend reading SQL SUM() for this specific question and going through the whole SQL course from w3schools.com. You really need to have a good grasp on creating queries in SQL if you want to create your own database. Database Normalization is also a very important concept to understand so that your tables can be designed in such a way that your data is usable in all situations.

Unfortunately, that is about all the assistance that we can provide with the information given. Once you read the links above, let us know if you have further questions and provide more details. Remember, you know what you are trying to do and you need to pass on the details that relate to the question so that a good answer can be provided. Otherwise you will only get vague answers. See How to ask good questions. We really do want to help, but it takes a good question to get detailed answers.