5/19/2023 0 Comments Ms access query parameter![]() On the Create tab, click Query Design in the Queries group.Ģ. In our case, we have a Company Name field in our Customers table, so we will create a query to extract that field.ġ. ![]() ![]() the Company Name may be in the Customer table), you will want to create a query that only has the Company Name. If the field you wish to use is already in a table (i.e. However, there is a way to accomplish this, with a little additional work.įirst, you will want to create a table or a query that has a list of the values you want to use in the drop-down list. One of the downsides to parameters is not being able to easily create a drop-down list from which users may choose what they wish to see. Parameter queries in Access 2010 are a great way to choose what you wish to see as your query result each time you run the query.
0 Comments
Leave a Reply. |