Create a form to filter data from a query (using multiple criteria) and generate a custom report.
Posted on 2016-09-20
I'm pretty new to Access so I'm not sure this is even possible. My goal is to create a form that enables users to filter data (using one or more criteria) and create a custom report.
I created a report that has college students' names, student year, the subject they are enrolled in, and a grade for that subject. All this data is coming from a separate query and each student has one row and one class. My report has about 300 rows (1 for each student) but I want to allow users to view fewer results in the report based on specific categories in the query. For example, it would be great if a user can use a form to select one or more subjects and just view a report for students enrolled in English and Math.