L
Laura
I have created a main report with 4 subreports. The subreports are in the
report footer because the subreports must be grouped but the main report is
not grouped. There are relationships between the tables that are used in the
report.
I have used the ApplyFilter macro action to filter the main and subreports.
The filter works fine for the main report but only pulls up one record for
the subreports. My test data has three records that fit the criteria. It's
as if the filter found the first matching record and then stops. The filter
is based on a parameter query. When I run the parameter query by itself, the
correct number of records are returned. I'm trying to stay away from coding,
but will use it if forced to by Access.
report footer because the subreports must be grouped but the main report is
not grouped. There are relationships between the tables that are used in the
report.
I have used the ApplyFilter macro action to filter the main and subreports.
The filter works fine for the main report but only pulls up one record for
the subreports. My test data has three records that fit the criteria. It's
as if the filter found the first matching record and then stops. The filter
is based on a parameter query. When I run the parameter query by itself, the
correct number of records are returned. I'm trying to stay away from coding,
but will use it if forced to by Access.