Question: This is for a project I'm working on using Microsoft Access. Any idea how to do this? Compute the profit margin for each item sold.

This is for a project I'm working on using Microsoft Access. Any idea how to do this?

Compute the profit margin for each item sold. Calculate the profit margin as (SellPrice-StdCost)/SellPrice. List Invoice, SaleDate, ItemID, SellPrice, Quantity, and computed ProfitMargin. Sort by ProfitMargin in descending order

I've created the tables & relationships, I just need tips on how to run the query. If there's a better place to look for this info please let me know!

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 Accounting Questions!

1. Casel Ivana's Ice Cream just finished its first six months of manufacturing and selling ice cream. The company has two main product lines, Ice cream cups and ice cream bars, both of which are...

plz read the case study and answer the given questions. Below is the link pasted for the data of this assignment. also please zoom in the pictures it should be clear. an upvote will be given for...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

HOW CHANGES IN THE FINANCIAL STATEMENTS AFFECT FINANCING DECISIONS: THE CASE OF JENLOU CO. Solutions to the Case Study JenLou Co. Working Papers Financial Summary of JenLou's Financial Options Option...

This project part will provide you with an opportunity to read and analyze an Annual Report, also called a Form 10-K, filed by a real-world company, Abbott Laboratories (ABT). This company has many...

The questions are in the images below Megan Brink is offered the possibility of investing $10,129 today at 5% interest per year in a desire to accumulate $16,500. How many years must Brink wait to...

Tempo Company's fixed budget (based on sales of 7000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (7,000 units) Cost of goods sold $2,800,000 Direct...

McCormick & Company, Inc. is one of the world's leading producers of spices, herbs, seasonings, condiments, and other flavorings for foods. Its products are sold to consumers, with some of the...

Suppose that consumers are concerned about theft, and so they are willing to use banks for some of their transactions even if the nominal interest rate is zero. Further, suppose that, the more...

Bramble Corp. produced 3 8 0 0 0 0 units in 1 6 0 0 0 0 direct labor hours. Production for the period was estimated at 3 9 0 0 0 0 units and 1 7 5 0 0 0 direct labor hours. A flexible budget would...

is it best practice is to make sure the replacement dell switch in a stack is the same version as the exisitng stack?