I've been asked to provide account details on a number of accounts in our system, so I'm building a query that pulls account details from one table and financial details from another. The query needs to include a field that sums all of the payments that a client made over a particular time period.
Considering that each of those payments exists in the financial table as a separate record, what is the best and/or easiest way for me to incorporate this into a single field on my query? Can I use DSum in this case? (I've never used DSum and just recently used DCount for the first time.) I'm assuming I'll need to build a sub query.
I appreciate any help or advice you can give.
Considering that each of those payments exists in the financial table as a separate record, what is the best and/or easiest way for me to incorporate this into a single field on my query? Can I use DSum in this case? (I've never used DSum and just recently used DCount for the first time.) I'm assuming I'll need to build a sub query.
I appreciate any help or advice you can give.