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.
Leave a Reply
Want to join the discussion?Feel free to contribute!