Pivot Table SQL - Multiple Column Fields

[RichDotson]

Does anyone know how to create a pivot table like the one below using SQL in Access? I can create a pivot table using SQL that will show me the Pieces_Pulled for each Move_Type but I cannot figure out how to get all three fields (Pieces_Pulled, Hours_Worked and PPH) under each Move_Type using SQL.


Any help is appreciated.

[June7]

Is this what you need http://allenbrowne.com/ser-67.html#MultipleValues

[RichDotson]

That article was perfect. After some trial-and-error with my SQL code I got it to work close to what I wanted. Thank you!