I have a report in Access 2003 which contains a subform. This report is designed to be run over a range of dates, and is displaying the sum() of the query's fields in the group footer section of the report. each row of the form's table =1 day of data.
In the subform, I link the id of the main table to the relatedID of my second table (a one-to-many relationship). For reports on single dates, this works just fine.
I've run into a problem: when my main report is run for multiple dates (i.e. a range), the subform only displays records which are related to the final row in the main form's query. Is there any way to get the subform to match against all rows returned in the main form without resorting to VBA?
As in, is there a proper feature for doing this or am I going to end up coding it myself?
