From the course: Access 2021: Queries
Join today to access over 24,800 courses taught by industry experts.
Solution: Calculate sales price for a product line
From the course: Access 2021: Queries
Solution: Calculate sales price for a product line
(upbeat music) - [Instructor] For this challenge, we were tasked with producing a price list for all of our products during a sale. So the first thing I want to do is just take a look at the input data that we have available in the products table. This will get us the product ID number and name. Here is the pricing column. So these are the original prices before the sale. And then we want to apply a discount to these prices based on the quantity sold. So anything that has sold more than 10,000 units will have a 25% price discount and everything else will just be a 10% discount applied to the original price. So that's the raw data that we have to work with. Let's go ahead and start a new query in design view. I'll pull in the products table, and I'll add in the product number, name, the original price, and let's also take a look at the quantity sold since we'll need to use this in our calculation. Now I know that I'm…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.