Access - Group multiple items under a single query

August 2017




Issue


In the statistical framework for a supermarket, we want to know the origin of our customers to improve our marketing activities. We know how to create queries to extract the clients from a city or region in particular. Problem: the number of requests is important. Is there a way to group them under a single query, but that could be customized at runtime?

Answer


That is what we call a parameterized query. It expects parameter at launch. To do this, query design mode, in the area of the city field test for example, type in expression: [What City?]. The brackets are required. Access seems to recognize a field that does not exist in reality. In fact, implementation of the application, a dialog appears asking this question: Which city? The user then enters the city in question, New York and all the related items are extracted.

Related


Published by aakai1056. Latest update on May 19, 2011 at 07:09 AM by aakai1056.
This document, titled "Access - Group multiple items under a single query," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).