80.2K

Verified Solution

Link Copied!

help please explain step by step in picture! the result should be same as shown in the picture

- Write a query to calculate and display all of the items that were sold from December 1,2018 through June 30, 2019. Include the following fields: InvoiceNum, InvoiceDate, Category, Item\#, itemDescription, RetailPrice, Cost, and Profit (calculated). The query results should be sorted by InvoiceDate, oldest to newest. Add a total row to the datasheet to display a count of the number of items sold, and the sums of each: RetailPrice, Cost, and Profit. - Name the query qryltemsPurchased_Dec2018_Jun2019. - Your query results should match those shown in the screen shot. If they do not, you need to revise your query. - Export these query results to Excel where you can choose to organize and analyze the data based on various fields, such as dates, category, specific items, etc. Look for additional ways to view and analyze the data. - Write a query to calculate and display all of the items that were sold from December 1,2018 through June 30, 2019. Include the following fields: InvoiceNum, InvoiceDate, Category, Item\#, itemDescription, RetailPrice, Cost, and Profit (calculated). The query results should be sorted by InvoiceDate, oldest to newest. Add a total row to the datasheet to display a count of the number of items sold, and the sums of each: RetailPrice, Cost, and Profit. - Name the query qryltemsPurchased_Dec2018_Jun2019. - Your query results should match those shown in the screen shot. If they do not, you need to revise your query. - Export these query results to Excel where you can choose to organize and analyze the data based on various fields, such as dates, category, specific items, etc. Look for additional ways to view and analyze the data

Answer & Explanation Solved by verified expert

See Answer