Question: Create a query in Query Design view based on the Events table and the Sum aggregate function to answer the question, What are the total
Create a query in Query Design view based on the Events table and the Sum aggregate function to answer the question, What are the total rental fees paid for each event type, sorted in descending order by the summed Rental Fee field? Use the Property Sheet to format the Rental Fee field with decimal places, and then close the Property Sheet. Run the query for the Event Type of Sports, the sum of the rental fees is $ Apply Best Fit to the fields, save the query as Fees by Event Query, and then close the query.
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
