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 19:30
When creating a presentation in libre office impress, where does the editing of slides take place? a. the slides panel b. the center panel c. the tasks panel, under the masters pages tab d. the tasks panel, under the layouts tab
Answers: 3
question
Computers and Technology, 22.06.2019 20:00
How is the number 372 written when expanded out to place values in the base 8 (octal) number system? a. 2 x 4 + 3 x 2 + 4 x 1 b. 3 x 64 + 7 x 8 + 2 x 1 c. 3 x 8 + 7 x 7 + 2 x 6 d. 3 x 100 + 7 x 10 + 2 x 1
Answers: 1
question
Computers and Technology, 23.06.2019 02:00
Which software would you use to create a print design? a. illustrator b. audacity c. reaper d. dreamweaver
Answers: 2
question
Computers and Technology, 23.06.2019 17:00
The more powerful, 60 volt cables and the main power shut off on an hev are both colored orange
Answers: 1
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
Social Studies, 19.01.2020 16:31
question
History, 19.01.2020 16:31
Questions on the website: 13722367