By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,470 Members | 966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,470 IT Pros & Developers. It's quick & easy.

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

P: 2
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.
Feb 18 '20 #1
Share this Question
Share on Google+
3 Replies

Seth Schrock
Expert 2.5K+
P: 2,949
Use the Sum() function in a query, with the Payer and Check Number columns in the GROUP BY clause.
Feb 19 '20 #2

P: 2
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.
Feb 20 '20 #3

Seth Schrock
Expert 2.5K+
P: 2,949
I recommend reading SQL SUM() for this specific question and going through the whole SQL course from 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.
Feb 20 '20 #4

Post your reply

Sign in to post your reply or Sign up for a free account.