Lateral Data Structure

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Hello,

I'm not sure I named the subject correctly, but here is what I'm trying to
do. I have a table with 3 fields. Fields are Style, Part, Quantity. For
each style, I have 1, 2, 3, or 4 different part numbers, and their respective
quantities. For example:

Style Part QTY
48RS Part X 2
48RS Part Y 1
48RS Part Z 3

I want to see this:
Style Part1 QTY1 Part2 QTY2 Part3 QTY3 Part4 QTY4
48RS Part x 2 Part Y 1 Part Z 3

Any guidance would be appreciated.

Thanks much,

Aaron
 
I was thinking you could use a Crosstab query, but because you want to
transpose more than one column, it wouldn't work.

If you use a Crosstab, you could get the Style on the x-axis, part on the
y-axis, and intersection would have the qty.

Other than that, there would be the need for multiple action queries to
un-normalize your data.
 
Back
Top