Hello! I'm pretty new to Access, and I'm stuck on this problem.
I'm trying to make a report for different proposals submitted this fiscal year by our organization. In the report, I'm also including the proposals that are still pending from previous years. To do this, I've created the main report to detail the current fiscal year and a Subreport that details previous years.
The main report is grouped by the 6 departments, and I'd like the subreport to be grouped by the 6 departments as well. My problem is that each department on the main report is showing all 6 departments on the subreport. Is it possible separate them so that each department on the main report only shows that respective department from the subreport?
Example for clarification:
It looks like this:
2018 a
I'd like it to look like this:
2018 a
Please let me know if there's a way I can do this. Thank you!
I'm trying to make a report for different proposals submitted this fiscal year by our organization. In the report, I'm also including the proposals that are still pending from previous years. To do this, I've created the main report to detail the current fiscal year and a Subreport that details previous years.
The main report is grouped by the 6 departments, and I'd like the subreport to be grouped by the 6 departments as well. My problem is that each department on the main report is showing all 6 departments on the subreport. Is it possible separate them so that each department on the main report only shows that respective department from the subreport?
Example for clarification:
It looks like this:
2018 a
2017 a
2017 b
2017 c
2018 b2017 a
2017 b
2017 c
2018 c2017 a
2017 b
2017 c
I'd like it to look like this:
2018 a
2017 a
2018 b2017 b
2018 c2017 c
Please let me know if there's a way I can do this. Thank you!