Posted by Thomas Bihn on 12/16/05 23:55

Thanks for the quick replies. I tried using the Excel pivot table, but
it simply shows the same number of columns as serial number styles and
displays a count of the number of each style for each board ID:

BoardID,Style1,Style2,Style3,Style4,Style5
21,1,1,1,3,1
43,1,1,1,3,1
76,1,1,1,3,1
78,1,1,1,3,1
etc...

Like the MSDN article on cross-tabs, it wants to perform some aggregate
function on the serial number values in the data area.

Thanks again.

*** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]