subject

Open the Payment By Month query in Design view. Change the first column so that instead of grouping by the payment date, you group by the month. Use the DatePart function to extract the month from the date. Name the column MonthNumber. Group by the MonthNumber field, and display the Sum of the first Total field and the Average of the Average field. Run the query. The first line should read 2 (as the month, representing February), with a total of $5,396.51 as the total payments received and $1,349.13 as the average payment amount. Ensure that the query results display a total at the bottom of the Total column, and an average at the bottom of the Average column. Save and close the query.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 20:30
In this lab, you complete a prewritten c program that calculates an employee’s productivity bonus and prints the employee’s name and bonus. bonuses are calculated based on an employee’s productivity score as shown below. a productivity score is calculated by first dividing an employee’s transactions dollar value by the number of transactions and then dividing the result by the number of shifts worked.
Answers: 3
question
Computers and Technology, 23.06.2019 02:30
Research data that is presented using descriptive language is said to be
Answers: 2
question
Computers and Technology, 23.06.2019 06:30
Which option correctly describes a dbms application? a. software used to manage databases b. software used to organize files and folders c. software used to develop specialized images d. software used to create effective presentations
Answers: 1
question
Computers and Technology, 23.06.2019 18:30
Janice recently received her college degree and is looking for a job. she is worried that since she just finished school, she will be required to repay her perkins and direct subsidized loans immediately. janice pulls out the paperwork she signed and reviews it again for repayment information. after reading all of the information, janice discovers that
Answers: 2
You know the right answer?
Open the Payment By Month query in Design view. Change the first column so that instead of grouping...
Questions
question
Mathematics, 01.11.2020 19:30
question
World Languages, 01.11.2020 19:30
question
Mathematics, 01.11.2020 19:30
question
History, 01.11.2020 19:30
question
Social Studies, 01.11.2020 19:30
question
History, 01.11.2020 19:30
question
Mathematics, 01.11.2020 19:30