Add a calculated field in the fourth column. Name the field Discount Amount. The field should multiply
Fantastic news! We've Found the answer you've been seeking!
Question:
Add a calculated field in the fourth column. Name the field Discount Amount. The field should multiply the number of items ordered, the price per item, and the discount field. This will calculate the total discount for each order. Format the calculated field as Currency, and add a caption of Discount Amt. Change the Total row to Sum. Run the query. Save the query as Order Summary. Return to Design view.
Related Book For
Manufacturing Processes for Engineering Materials
ISBN: 978-0132272711
5th edition
Authors: Serope Kalpakjian, Steven Schmid
Posted Date: