Create a dynamic access report 10 in 1

00:00 The Idea
01:10 import the sample data
02:37 create unique values list
03:12 create the search form
03:55 Create the report
06:15 clear fields code
07:07 the filter code

If you are required to do more than one report based on different criteria, it is not logical to make a query and report for each search criterion, especially if the search criteria are overlapping. For example, if we have the search criteria, which are the school, the gender of the teacher, the subject, and the region, we will need about ten reports, and we need each separate query report, which is illogical and is a reason of database problems, as it is considered a defect in the database design.

Link to excel file
https://docs.google.com/spreadsheets/d/1XoULrblxnXggfgpKOEdEb-lylFf3KyIpqxa35E4bgKU/edit?usp=sharing
link to access database
https://drive.google.com/file/d/1pLtvNzjnyUVyFd2Xw0C7IzGRoXEEreJj/view?usp=sharing
the code
https://drive.google.com/file/d/1wbLZ8M30PNQU224ov22TKSKKpVfQJhQl/view?usp=sharing

Видео Create a dynamic access report 10 in 1 канала askfarouk