I display the list of payments and receipts in a tabular control on a form based on a table.
I want to display the totals of the two columns at the bottom.
If I apply a form-based filter to display only a subset of the entire table, I want the totals at the bottom of the form to display the totals only of the items displayed.
The main form can not be based on a query because I want the option of changing the data displayed. I realize that I would then have to refresh the form for the totals to be adjusted.