Create additional select queries for What SUP using computed fields. (Use the Ch11-02 student file, or use

Question:

Create additional select queries for What SUP using computed fields. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)
a. Create and print a select query that lists the product name unit price, unit cost, and unit gross profit for all products. Sorted in descending order by unit gross profit price. (Hint:You’ll need to create a computed field titled Unit Gross Profit whose formula is the product’s unit price minus unit cost.) Save this query as Ch 11 Assignment 5a before you print it.
b. Create and print a select query that lists the product name, unit price, quantity, and sales value for all paddles.  Sort the query by unit price in ascending order. Save this query as Ch 11 Assignment 5b before you print it.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: