Reverse Crosstab Query

[TastyWheat]

I was able to get a crosstab query to change this:

Name      Class         Date
---------------------------------
John Doe  Orientation   1/1/2005
Jane Doe  Orientation   1/1/2005
Jane Doe  Shift Mgmt.   1/10/2005

to this:

Name      Orientation   Shift Mgmt.
-----------------------------------
John Doe  Yes           No
Jane Doe  Yes           Yes

Now I need a crosstab query to do the opposite (Date excluded). Is something like that possible? I keep getting column headers with 'Yes' and 'No'. Or if you know any kind of query to get the result I'm looking for let me know. Otherwise I'll be making an ugly function or several queries (one per class).