Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the Query Wizard to create a crosstab query based on the Events table with the Time field as row headings and the Event Type
Use the Query Wizard to create a crosstab query based on the Events table with the Time field as row headings and the Event Type field as column headings. Sum the Rental Fee field, and name the query Event Time and Type Crosstab Query. Display the query in Design view. Use the Property Sheet to format the last two columns with decimal places, and then close the Property Sheet. Run the query, apply Best Fit to the fields, save the query, and then close the query.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started