Cross Tab with text values and no totals

[Access_Help]

I need a query set up similar to a cross tab, I just want to show the text values, without summary totals. How do I achieve this?

Columns: Name, Grade_Unit1, Grade_Unit_2 etc
Data Rows: John, C, A

 

[pbaldy]

Try Max or Min instead of Sum.

 

[JHB]

If you can't get it, then post some data in an Excel sheet or MS-Access database.