From the course: Access 2016: Queries

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Solution: Identify the highest and lowest pricing markup

Solution: Identify the highest and lowest pricing markup

From the course: Access 2016: Queries

Start my 1-month free trial Buy for my team

Solution: Identify the highest and lowest pricing markup

“

(techno tone) - [Voiceover] Here's how I would go about finding the product with the highest and lowest markup percentages. First, let's take a quick look inside of the products table. And I'll find here I've got the item name and the price to our customers. In order to find the wholesale cost, though, I have to go look in the related data table, and that's gonna be the Products Descriptions one here, and that'll map the item name to the wholesale cost that we can find way over here. So those are the two tables that we need to make use of. Then go up to the Create tab, create a new query in Design View, and pull in those descriptions and the products. Now from the product descriptions table, I'm going to pull in the item name here and the wholesale cost, and then from the products table, we'll grab the price. Let's go ahead and run it to see what it looks like. And I can see that I've got lots of the same item name repeated over again, and that's because each item has multiple sizes…

Contents