Sorry Lynn, I didn't see your solution before posting my version of the same thing.

I find it strange that TSQL doesn't have built-in cross-tab query functionality whereas Access does. It's...

Sorry Mark, I didn't see your solution before posting my version of the same thing.

I find it strange that TSQL doesn't have built-in cross-tab query functionality whereas Access does. ...

How does this approach work for you:

--first a temp table and data to test with:

Create Table #Products (ID int, Description varchar(30))

INSERT INTO #Products (ID, Description)values (1, 'Hairy')

INSERT INTO #Products (ID,...

Thanks Mr. Magoo.

I think the problem I'm seeing in approach 2 is due to the left joins' "on" statements. For example, when the filter Na.Number < Nb.Number can be...