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.
Watch video Parameter Queries in Access Database online without registration, duration hours minute second in high quality. This video was added by user Q Visible 10 February 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,228 once and liked it 69 people.