29. Create a form that enables a manager to choose an employee, starting date, and ending date and display a chart of sales by model type for those conditions. Hint: Use parameters in the query to refer to the control values.
QL
SELECT Bicycle.ModelType, Sum(Bicycle.SalePrice) AS SumOfSalePrice
FROM Bicycle
WHERE (((Bicycle.EmployeeID)=[Forms]![Ex0629]![EmployeeID])
AND ((Bicycle.OrderDate) Between [Forms]![Ex0629].[StartDate] And [Forms]![Ex0629]![EndDate]))
GROUP BY Bicycle.ModelType;
Form: Ex0629