Hi,
I’ve a Form with several Subforms linked by Master/Child and a series of filters in the main form to select certain groups of records. My preferred way to filter is by using Recordsource with different Where clauses.
I want to display all kinds of stats (like Count, Sum, etc) for the ENTIRE datasets that remain under each subform.
To give a concrete example: say that the Main Form displays a list of Authors from many countries and say there is a subform with the list of all their books. Suppose form and subform are linked by a BookID key.
Now, filter the main form to show all the British authors and want to display the TOTAL number of books that there under the filtered subform, in other words how many books were written by those authors.
Surely this can be achieved by using many separate queries (with subqueries when needed) and by displaying the looked-up values, but I wonder if there is a better, more elegant way to accomplish it.
Appreciate your help!
I’ve a Form with several Subforms linked by Master/Child and a series of filters in the main form to select certain groups of records. My preferred way to filter is by using Recordsource with different Where clauses.
I want to display all kinds of stats (like Count, Sum, etc) for the ENTIRE datasets that remain under each subform.
To give a concrete example: say that the Main Form displays a list of Authors from many countries and say there is a subform with the list of all their books. Suppose form and subform are linked by a BookID key.
Now, filter the main form to show all the British authors and want to display the TOTAL number of books that there under the filtered subform, in other words how many books were written by those authors.
Surely this can be achieved by using many separate queries (with subqueries when needed) and by displaying the looked-up values, but I wonder if there is a better, more elegant way to accomplish it.
Appreciate your help!