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
docs.google.com/spreadsheets/...
link to access database
drive.google.com/file/d/1pLtv...
the code
drive.google.com/file/d/1wbLZ...

[@saipuvvada3977]

excellent.. exactly what I needed. well explained - made it easy to get this done quick.

[@askfarouk]

Thanks for your positive comment

[@SibrenFetter]

Fantastic! This was exactly what I needed for work!

[@askfarouk]

Thanks for the positive comment

[@habibullah2461]

Great, very simple and clear to understand.

[@askfarouk]

Thanks sir

[@fadzilhashim8894]

Jazzak kallah hu khyr. Thank you so much.

[@mathematiquesinformatique1423]

شكرا لك

[@medoAlshehri1990]

Really professional, thank you sir

[@askfarouk]

thanks for your positive comment

[@romelghosn6663]

Thank you farouk for the video, it is really helpful. can you help explain what to do if we need to add a date range filter to this dynamic report. thanks

[@hasansafi3341]

thank you for this video. what if the filter I want to use is for numeric values? thank you.

[@bobykumar3960]

great work,,,,,,,,thanks a lot

[@askfarouk]

Thanks for the positive comments

[@tesseract7711]

Thank you,
Can you please guide and help to create a filter to select multiple selections from a combo box and provide results based on the filter.

[@askfarouk]

very good idea , I never tried it out let me try.

[@tesseract7711]

@@askfarouk thank you, will wait for your reply..

[@oex1545]

السلام عليكم ورحمة الله وبركاته ، استاذ عندي سؤال ، لو عندي مثلا الرموز Aboq125 واحتاج اعرف النتائج اللي ممكن تظهر لما نعيد نرتب هذه الرموز هل توجد طويقة معينه؟

[@aimedia2023]

Great very impressive

[@askfarouk]

Thanks

[@mithunbalajimg5779]

Holy shit bro i found it finally

[@jammaad7386]

انت زعيم

[@askfarouk]

تسلم يا غالي

[@sherifokba1560]

Thank you i followed the steps and it works great, but i have a problem that one of my comb boxes is searching dates and it give me error, i can not filter my report by date. can you advice me what is the problem? thx

[@askfarouk]

My advice is to create another report with date filter and open this one if the date is not null.

[@hasansafi3341]

@@askfarouk what if the comboBox was long or integer? thanks.