From the course: Access 2016: Queries

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Challenge: Identify the highest and lowest pricing markup

Challenge: Identify the highest and lowest pricing markup

From the course: Access 2016: Queries

Start my 1-month free trial

Challenge: Identify the highest and lowest pricing markup

“

- [Voiceover] Let's wrap up this course with one last challenge. I'd like to find out what product has our highest and our lowest markup percentage. You can calculate the markup percentage by dividing each product's price by the wholesale cost that you'll find in the database. See if you can create a query that only returns these two products and nothing else. This challenge should take you about five to 10 minutes.

Contents