Create a crosstab query based on the Available Inventory query.

i. Create a crosstab query based on the Available Inventory query. Use the VehicleMake field for the row headings, the VehicleYear field for the column headings, and the VehicleSalePrice field for the column and row intersection. Average the VehicleSalePrice field. Save the query asAvailable Inventory_Crosstab. What I need help is putting  the VehicleSalePrice field for the column and row intersection.

Order the answer to view it

Assignment Solutions
Assignment Solutions