I am new to creating queries and do not know how to build this expression.
I have a tables that lists each transaction in accounts payable and another for each check. How do I get only the total amount of each check and not all the entries for all the transactions?
The problem is that many invoices hit multiple g/l accounts and each breakdown creates a new transaction. I cannot sort only by check number because I also need to know all the invoices that are unpaid.