Report filter
I created a toolbar to open a report using filtered criteria but the results are incorrect as per grouping levels set in the report. As per enclosed JPG you can see the selection made in the toolbar doesn’t yield one group, but two groups (the second one in the JPG is a CO-OP group) show up in the results, not to mention the year filter not being applied either. The record source of the report is 2 tables & a query & the toolbar is meant to whittle down the recordsource even further once the report is opened. Any help would be appreciated.
I created a toolbar to open a report using filtered criteria but the results are incorrect as per grouping levels set in the report. As per enclosed JPG you can see the selection made in the toolbar doesn’t yield one group, but two groups (the second one in the JPG is a CO-OP group) show up in the results, not to mention the year filter not being applied either. The record source of the report is 2 tables & a query & the toolbar is meant to whittle down the recordsource even further once the report is opened. Any help would be appreciated.