Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a query to calculate the per unit price of the archived sales. a . Include the following fields in this order: the ItemName field

Create a query to calculate the per unit price of the archived sales.
a. Include the following fields in this order: the ItemName field from the Items table and the Quantity and SaleTotal fields from the SalesArchive table.
b. Add a calculated field to the far right of the query to calculate the value of the SaleTotal divided by Quantity. Name the field: CostPerUnit Run the query to check your work. (Hint: There should be 240 records in the query results. Observe that some of the values do no appear properly)
c. Go back to Design view and modify the CostPerUnit field to use the Currency format. Run the query again to check your work.
d. Save the query as CostPerUnitQry and then close the query.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Introduction To Databases And Data Warehouses

Authors: Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov

1st Edition

1943153191, 978-1943153190

More Books

Students also viewed these Databases questions

Question

What happens if foreign return is greater than domestic return

Answered: 1 week ago