Question: 1 7 . Create a query to display sales for more than ( $ 6 0 . 0 0 ) from the

17. Create a query to display sales for more than \(\$ 60.00\) from the SalesArchive table.
a. Include the following fields in this order: the SaleDate from the SalesArchive table, ItemName field from the Items table, and SaleTotal from the SalesArchive table.
b. Add criteria to the SaleTotal field to return only sales greater than \(\mathbf{60}\).
c. Specify the sort order in the query, so the results always display the records with the highest values in the SaleTotal field first. Run the query to check your work. (Hint: There should be 5 records in the query results.)
1 7 . Create a query to display sales for more

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Need guidance to complete the following steps 7. Create a query to display sales of truffle flavored popcorn with a quantity greater than ten from the OnlineSales table. a. Include the following...

Q:

1. Oper the start lie AC2016-Capstone-Level2. NOTE: If necessary, chable active content by dicking the Enable Content button in the Message Bar. 2. The file will be renamed automatically to include...

Q:

Open the Sales table and add three records to the table with the following data. ( Hint: The first field in the table, SaleID, is an AutoNumber field, so there is nothing to enter for each record. )...

Q:

Open the start file AC2019-Capstone-Level3 . NOTE: If necessary, enable active content by clicking the Enable Content button in the Message Bar. The file will be renamed automatically to include your...

Q:

Populate.sql: Please show with steps on cmd SQL format Rem ******** dropping tables ************* DROP TABLE SALGRADE; DROP TABLE EMPLOYEE; DROP TABLE DEPT; Rem ******** create table DEPT...

Q:

New Perspectives Access 2013 Tutorial 5: SAM Project 1a Physical Therapy Specialists, P.C. creating specialized queries and enhancing a databaseName PROJECT DESCRIPTIONJennifer Christie wants to...

Q:

GoGopher! Amol Mehta, a recent college graduate living in Boulder, Colorado, spent months earning money by running errands and completing basic chores for family members and acquaintances, while...

Q:

Instructions: The structure for the Outlets table is shown in Table A1A -1 and the data is shown in Table A1A-2. The structure for the Sales Rep table is shown in Table A1A-3 and the data is shown in...

Q:

Open the Top't Corn Sales Database Access file from the location where you saved the data files for this project. ( Downloaded from the Resources link. ) Import records from the Excel file DEC 3 - 9...

Q:

Question 1 [6] Create a query to display the number of times patient cancelled appointment made with the doctors by making use of NOT operator. Your output must resemble the one below. Cancelled...

Q:

prepare for Meng Kong a) an income statement for the year ended 31st december b) A Balance sheet as at 31st December 2018

Q:

Harley Corporation issued $337,500 of 6%, 10-year, nonconvertible bonds with detachable stock purchase warrants. Each $1,000 bond carried 20 detachable warrants, each of which was for one share of...

Q:

Is the house of Tutors financed through debt or equity? How much does House of Tutors owe to vendors?

Q:

You are considering an investment opportunity that lasts for one year. The project will generate cash flows of either $2000 or $1000 next year, depending on whether the economy is strong or weak,...