You Want to Add the PaymentDate Field from the Payments

question 60

Essay

You want to add the PaymentDate field from the Payments table in the query shown in the accompanying figure. Describe how you can do this.

---

Definitions:

Inventory

The total amount of goods and materials held in stock by a business, intended for sale or production purposes.

Ordinary Course

Activities or transactions that are regular, customary, and in keeping with the normal operations of a business or individual’s day-to-day life.

Durable Goods

Consumer goods that have a long life span (over three years) and are used over time, such as cars or appliances.

Farm Products

Goods that are derived from agriculture, including crops and livestock.