55. Totals Query (Totals_EmployeeSales): What are the total sales for each employee? Create a query that...

 

Transcribed Image Text:

55. Totals Query (Totals_EmployeeSales): What are the total sales for each employee? Create a query that shows EmployeeID, LastName, and TotalSales for each employee. You will need to group the employees and add the Amount of each sales record in the database. Sort the results alphabetical by last name. You may use Table 1-12 below to develop the lower part of your query. Table 1-12: Design for query Totals_EmployeeSales Field Table Total Sort Show Criteria Or: 55. Totals Query (Totals_EmployeeSales): What are the total sales for each employee? Create a query that shows EmployeeID, LastName, and TotalSales for each employee. You will need to group the employees and add the Amount of each sales record in the database. Sort the results alphabetical by last name. You may use Table 1-12 below to develop the lower part of your query. Table 1-12: Design for query Totals_EmployeeSales Field Table Total Sort Show Criteria Or: