Access has a transform keyword that you can use to help construct SQL queries. It basically transposes data, so that it displays columns as rows.
Does anyone know if MS SQL has a similar keyword or how you would write the SQL to achieve the desired result?
Regards
D
