Answered step by step
Verified Expert Solution
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 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started