Hello,
I have the following table:
Cabinet ID DoorQty Width String Height String PanelQty PanelShortName PanelName PanelWidthString PanelLengthString PanelMaterial RailQty RailShortName RailName RailWidthString RailLengthString RailMaterial StileQty StileShortName StileName StileWidthString StileLengthString StileMaterial
1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DBR Door Bottom Rail 2 11 13/16 2 DLS Door Left Stile 2 30 1/4
1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DBR Door Bottom Rail 2 11 13/16 2 DRS Door Right Stile 2 30 1/4
1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DTR Door Top Rail 2 11 13/16 2 DLS Door Left Stile 2 30 1/4
1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DTR Door Top Rail 2 11 13/16 2 DRS Door Right Stile 2 30 1/4
What I need this data to look like, in the report is this:
Cabinet ID DoorQty Width String Height String PanelQty PanelShortName PanelName PanelWidthString PanelLengthString PanelMaterial RailQty RailShortName RailName RailWidthString RailLengthString RailMaterial StileQty StileShortName StileName StileWidthString StileLengthString StileMaterial
1 2 14 13/16 30 1/4 2 DFP Door Flat Panel 11 9/16 27 2 DBR Door Bottom Rail 2 11 13/16 2 DLS Door Left Stile 2 30 1/4
2 DRS Door Right Stile 2 30 1/4
2 DTR Door Top Rail 2 11 13/16
Basically, I need to now show any repeated information, but all unique information needs to be on a new line.
Now, I have 4 separate queries that I use to make the above table, and I will post them (along with the database structure) if it will help to figure what I need to do.
Thank you so much for any help you can provide.