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
Show the ID and OrderDate fields of any records with Sales at least $ 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 threemonth range, with separate totals for each
year.
Show all fields of any records with Sales below $ 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 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
