hi
i am trying to create a cross tab query but i cant seem to display the info how i want it.
i have two tables
table_wheelcavities table 1
wheelcavities_ID
vehicle_IDFK
DateAdded
Mileage
PrintName
MaximoNo
table_wheelCavities_M2M table 2
wheelcavities_M2M_ID
wheelcavities_IDFK
DateAdded
Wheel_IDFK
WorkType_IDFK
PositionOfOilInjector
length
width
depth
height
thickness
rollover
table_wheelcavities is left join to table_wheelcavities_M2M
so from table 2 user chooses worktype_IDFK, options are flats,cavities,flange heights, flange thickness, real flange thickness, rollover,
and adds dimension, not all the fields are filled in, so for example, if the user chooses flats, he only uses length, width and depth.
so in the crosstab query i want to be able to display the dimensions, with worktype as the column headers and the dimension type as the row header, ive tried to use expr as the row headers and the dimensions as values, but i just cant get it to work.
i am trying to create a cross tab query but i cant seem to display the info how i want it.
i have two tables
table_wheelcavities table 1
wheelcavities_ID
vehicle_IDFK
DateAdded
Mileage
PrintName
MaximoNo
table_wheelCavities_M2M table 2
wheelcavities_M2M_ID
wheelcavities_IDFK
DateAdded
Wheel_IDFK
WorkType_IDFK
PositionOfOilInjector
length
width
depth
height
thickness
rollover
table_wheelcavities is left join to table_wheelcavities_M2M
so from table 2 user chooses worktype_IDFK, options are flats,cavities,flange heights, flange thickness, real flange thickness, rollover,
and adds dimension, not all the fields are filled in, so for example, if the user chooses flats, he only uses length, width and depth.
so in the crosstab query i want to be able to display the dimensions, with worktype as the column headers and the dimension type as the row header, ive tried to use expr as the row headers and the dimensions as values, but i just cant get it to work.