Exercise: MS Access Queries 3
-
- Calculate paid CommissionAmount (in USD) for each transaction as a product of TransactionSize and Commission
- Calculate TransactionDate using year 2020, month, day, and using DateSerial() for each transaction
- Calculate StartDate for each customer, based on maturity days and transaction Date... using DateAdd("d",[«number»],[«date»])
- Input the Start date of customer 5 & customer 19 (result 1, result 2) in https://forms.gle/7YRmC4CehbdGBBby7
- Input average CommissionAmount from all transactions as result 3 in the form
Last modified: Wednesday, 20 April 2022, 12:36 PM