Good evening,
I have searched the database to try to find a solution to my question to no avail, so I am finally going to post a thread.
I have a database that tracks Lot information for a subdivision. It tracks payment history and then prints an invoice for the annual dues payment. Owners have an option of paying in full or making five monthly payments. Some owners, such as builders, own multiple lots and we need the balance due for these lots to show up on one invoice.
I created a report for the invoice and have set groups for the last name and the lot number. This pulls all the lots for the last name onto the invoice. The payment date and amount shows up on the detail section of the report. I have a calculated total that shows the balance due for each transaction simply by subtracting the payment from the annual dues amount.
Here is my problem. I want to have a total balance due for each lot, as well as a grand total at the bottom of the invoice page showing total annual dues (for all lots), total payments made (for all lots) and total balance due. If I make the annual dues field and the payment amount field a running sum, it shows up correctly in the detail section of the report. (Although it is showing up as a cumulative total for each lot, rather than the balance due for each lot).
However, when I try to use the running sum at the bottom of the page to show my totals I only get the very last entry as a result.
Any suggestions on how I can fix this?
Thanks in advance,
My Ski
I have searched the database to try to find a solution to my question to no avail, so I am finally going to post a thread.
I have a database that tracks Lot information for a subdivision. It tracks payment history and then prints an invoice for the annual dues payment. Owners have an option of paying in full or making five monthly payments. Some owners, such as builders, own multiple lots and we need the balance due for these lots to show up on one invoice.
I created a report for the invoice and have set groups for the last name and the lot number. This pulls all the lots for the last name onto the invoice. The payment date and amount shows up on the detail section of the report. I have a calculated total that shows the balance due for each transaction simply by subtracting the payment from the annual dues amount.
Here is my problem. I want to have a total balance due for each lot, as well as a grand total at the bottom of the invoice page showing total annual dues (for all lots), total payments made (for all lots) and total balance due. If I make the annual dues field and the payment amount field a running sum, it shows up correctly in the detail section of the report. (Although it is showing up as a cumulative total for each lot, rather than the balance due for each lot).
However, when I try to use the running sum at the bottom of the page to show my totals I only get the very last entry as a result.
Any suggestions on how I can fix this?
Thanks in advance,
My Ski
