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.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *