Skip to Content

Create a cross tab query based on the Available Inventory query.

Submitted by • August 27, 2018

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.

Voted by:
Voted by answersmarket

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>