Hi there,
I have this as result from a SQL Query:
AdrNr Merkmal
1149 Referent
1149 Presse
1411 Referent
1411 Baugeschäft
1411 Lehmbau
is it possible with Access2000-SQL to create a result like this from
the given table above:
AdrNr Merkmal1 Merkmal2 Merkmal3
1149 Referent Presse
1411 Referent Baugeschäft Lehmbau
or alternatively as comma separated:
1149, Referent, Presse
1411, Referent, Baugeschäft, Lehmbau
The problem is: The table is very big, so doing a loop
record-by-record will take very long.
Regards
Marian
--
Tipps und Tricks zu PHP, Coaching und Projektbetreuung
http://www.heddesheimer.de/coaching/