% Then I'm not calling it the right thing... just the name of the type
% of query that was told. The kind of query I'm talking about is the % one that rotates the result set from tall to wide. Basically doing % exactly what the OP had asked for. If
Hmmm... You mean like taking results
1 a
2 b
3 c
4 d
and changing it to
1 2 3 4
a b c d
or such? I'm certainly confused.
More or less, yes. exactly that.
ADOdb - PivotTableSQL() and it works with any database engine.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services