I got it to work by grouping, not sure what I was doing wrong the first 100 times, but I may have been grouping in the wrong order. The only thing I lack now is how to add the subtotal of board feet and linear feet for each width.
When I was using hard coded widths, (a separate query for each width), I made each query a table in a table group and used the summary row to add the subtotals. Now that it is one query, how can I make it insert the subtotals after each width ie after 1.375" wide then after 1.75" wide …… I need a total bdft and lnft of all widths at the end, which is easy using the summary portion of the table. Just not sure on the subtotals within each width. Thanks
