Problem $2$: Create a parameter query to obtain a list the InventoryID, Item Name, and UnitsOnHand fields for specific categories of inventory items. Before running, the parameter query should ask the user to indicate whether the items they are looking for coffee or tea inventory and whether these items are flavored or not. The prompt text of each parameter should make clear to the user what input values are possible. The resulting dynaset should be sorted in ascending order by OnHand quantity and make sure only the three fields mentioned display in the dynaset.

Save the query as gryProblem$2.$

HINT: to understand how to handle the Yes$/$No data type in this query, first open tblinventory and click into a few cells in the Flavored column to see how this data type works.