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
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.
Step by Step Solution
3.52 Rating (159 Votes )
There are 3 Steps involved in it
a b Product Name Sleeping One Candice Appleby Zoomer Glide GS Nalu Badfish 2 Veneer Raven N... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1512_605d88e15f72b_680060.pdf
180 KBs PDF File
1512_605d88e15f72b_680060.docx
120 KBs Word File
