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