Question: Create a query in Design view, using the Cap 1 Inventory table to answer the question For each item name, display the cost and calculate
Create a query in Design view, using the Cap Inventory table to answer the question For each item name, display the cost and calculate the markup for each item if marked up of cost In addition, calculate the retail price by adding the cost and markup? Add the fields in that order. Name the first calculated field Markup and name the second calculated field Retail Price. Run the query and apply Best Fit to all of the fields. All numeric fields should be formatted as Currency, with Decimal Places. Save the query as Cap Markup Query and close it
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
