subject

Open the Order Totals By Month query in Design view. Change the first column so that instead of grouping by the order date, you group by the month. Use the DatePart function to extract the month from the date. Name the column MonthNumber. Run the query. The first line should read 5 (as the month, representing May), with a total of $1409.17. Save and close the query.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 13:30
Use the keyword strategy to remember the meaning of the following word. the meaning for the word has been provided. write your keyword and describe the picture you would create in your mind. centurion: a commander in the army of ancient rome. keyword: picture:
Answers: 2
question
Computers and Technology, 22.06.2019 17:00
Your company has 1,500 desktop computers running windows 7. you want to upgrade them to windows 10. which type of microsoft license would be best suited in this situation?
Answers: 3
question
Computers and Technology, 23.06.2019 20:00
Match the file formats with the types of multimedia they can store
Answers: 2
question
Computers and Technology, 24.06.2019 01:30
Hazel has just finished adding pictures to her holiday newsletter. she decides to crop an image. what is cropping an image?
Answers: 1
You know the right answer?
Open the Order Totals By Month query in Design view. Change the first column so that instead of grou...
Questions
question
Mathematics, 14.09.2019 07:20
question
English, 14.09.2019 07:20
question
Mathematics, 14.09.2019 07:30
Questions on the website: 13722360