Need a list of value no aggregate data

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
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;
 
Back
Top