Pivot table like look but with text HELP!

[adtranzit]

HI need to connect to a ODBC source and create a pivot table like view of the data (i dont need the ability to change this view by the user - if that is a n issue!)

here is my data...
car1,workorder111,DATE2007
car2,workorder123,DATE2007
car2,workorder222,DATE2008


and what im want to achieve in column view

DATE2007 DATE2008
Car1 workorder111
Car2 workorder123 workorder222


Is this possible and if required which book would cover the area on ODBC and this kind of issue? Pivots are great but wont work with trying to give my customers a visual view with real text data -HELP

 

[Fazza]

Hi,

Please use TRANSFORM in the SQL. As you have text in the data field, maybe use MAX for the aggregate data function. I'm sure I have previoslu posted on using TRANSFORM so a search of old posts might have some further relevant info. Regards, Fazza

TRANSFORM MAX(MD.WorkOrder)
SELECT MD.Job
FROM MyData MD
GROUP BY MD.Job
PIVOT MD.Date