Need a list of value no aggregate data

[Dan]

If I have a table:
Class Topic Name
A English Marc
B Math Dan
C Math Lisa
A English John
A Math Dave
B History Ling

Any idea how I can make it to:

English Math History
A Marc Dave
John
B Dan Ling
C Lisa

 

[KARL DEWEY]

Would this work for you --
TRANSFORM First(Dan.Name) AS FirstOfName
SELECT Dan.Class
FROM Dan
WHERE (((Dan.Class) Is Not Null))
GROUP BY Dan.Class, [Topic] & IIf([Name] Is Null,"-",[Name])
PIVOT Dan.Topic;

 

[MGFoster]

If I have a table:
Class Topic Name
A English Marc
B Math Dan
C Math Lisa
A English John
A Math Dave
B History Ling

Any idea how I can make it to:

English Math History
A Marc Dave
John
B Dan Ling
C Lisa

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Cross-tab query:

TRANSFORM FIRST([Name]) As theValue
SELECT [Class]
FROM table_name
GROUP BY [Class]
PIVOT Topic

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBScOvtYechKqOuFEgEQKvVQCg9TDbs+RyTEMwuJq/1Yp3e4N6LEgAn1zD
NOfeNGEq+SSHEjo+HjKaX/ND
=d6Td
-----END PGP SIGNATURE-----