Thanks Luis. That's a lot for me to digest, and while I get the gist of it I think it may be overkill for what I'm trying to accomplish.

We have a limited number of product lines, and since I need create product-line-specific specification sheets anyway it may be easier for me to simply create a crosstab for each one. Now that I'm thinking a bit more about this, the benefit of individual queries by product line might be beneficial in other ways as well.

I'll ponder some more, but sincerely appreciate the help!