File Horne Create External Data Database Tools Hele Design Tell me what you want to do +! Property Sheet obx Union Pass through Data Definition Table Names Select Make TotalParameters Run View Append Update Crosstab Delete Insert Rows Insert Columns x DeleteRows X Date Columns Show Table Buder 2 Reture All Query Setup Table Show/Hide Ruth Query Type Employee Payments All Tables Search Employee Into P Employee in El Zoom OK Employee Last Name First Name Hire Oale Cammin Cancel morando Emporea Sales by Employee Com Bih Empoyee Comodo font Field Last Name Table Employee Info Sort Ascending Show Criteri Ask me anything 1.00 Point AC Step 322. Calculato a Loan Payment with the PMT Function The employees will receive three payments instead of a single quarterly commission check. Add a new column to the query. The field should calculate the value of the payments using a rate of .06/3, 3 payment periods, a present value of the Actual Sales field multiplied by .06, and 0 for the future value and type. Change the field name to Payment