Rather than have multiple queries with different criteria it sometimes more usable and maintainable to ask the user for the criteria as the query is run. These types of queries are known as parameter queries. the parameter being the value the user enters which is then dynamically inserted into the pre-ordained criteria field.
On this page of the site you can watch the video online Parameter Queries in Access Database with a duration of hours minute second in good quality, which was uploaded by the user Q Visible 10 February 2015, share the link with friends and acquaintances, this video has already been watched 6,433 times on youtube and it was liked by 70 viewers. Enjoy your viewing!