Question: please tell what to do ! step by step ASAP Reports: For each Region, show the sum of Sales, grouped by ProductContainer. You can include

please tell what to do! step by step ASAP
Reports:
For each Region, show the sum of Sales, grouped by ProductContainer. You can include the
sums using the "Summary Options" button in the third Report Wizard window, where you select
ascending or descending order - choose the summary (sum) only, not summary and details. Use
the Layout View to expand any text boxes too small to display the Sales values - these will
display as ######### filling up the text box.
Show the sum of Profit for each combination of {Province, ProductCategory, OrderPriority}. Group
the records by Province, then ProductCategory, then OrderPriority, and only show the sum of
Profit, not other details.
Queries:
Show the ID, OrderDate and ShipDate fields (only) of any records where the Region is West and
the OrderDate is in 2019.
Show the ID and OrderDate fields of any records with Sales at least $100 AND the ShipMode is
Express Air AND the ProductContainer is Large Box
For each Region, show the sum of Sales from the months of January through March (use
ShipDate). The sum should be for the entire three-month range, with separate totals for each
year.
Show all fields of any records with Sales below $4000 AND the ShipMode is Express Air.
For each Region, show the sum of Sales for each OrderPriority. You should have one sum for
each {Region, OrderPriority pair.
Show average Sales for each Province, using all records with a 2020 ShipDate, You should only
have one average value per province.
Show all fields of any records where the ShipMode is Delivery Truck and the ProductContainer is
not Jumbo Box (in the query criteria, you can use the ">" operator for "not equal to").
 please tell what to do! step by step ASAP Reports: For

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!