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:20
Terri needs to insert a cover page into her document. where should she go to access the commands to do so? o insert tab, objects group o insert tab, illustrations group o insert tab, pages group o insert tab, media group submit
Answers: 1
question
Computers and Technology, 22.06.2019 21:40
Develop a function to create a document in the mongodb database “city” in the collection “inspections.” be sure it can handle error conditions gracefully. a. input -> argument to function will be set of key/value pairs in the data type acceptable to the mongodb driver insert api call b. return -> true if successful insert else false (require a screenshot)
Answers: 2
question
Computers and Technology, 23.06.2019 04:31
Jennifer has to set up a network in a factory with an environment that has a lot of electrical interference. which cable would she prefer to use? jennifer would prefer to use because its metal sheath reduces interference.
Answers: 1
question
Computers and Technology, 23.06.2019 11:00
How should you specify box sizes on a web page if you want the boxes to vary according to the font size of the text they contain? a. in pixels b. in inches c. as percentages d. in em units
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, 08.04.2020 00:21
question
Mathematics, 08.04.2020 00:22
Questions on the website: 13722367