CrossTab Query that shows original data (text)

[greene2j]

I am a scheduler and would like to build a pivot table in Excel or a Cross
Tab Query in Access that shows the data in its original form (text) instead
of calculating the count, sum, avg., etc.

Row headings would have member’s names. Column headings would have times.
Data items would be the name of the assignment.

Any suggestions would be appreciated.

Thanks.

Jim G

 

[Duane Hookom]

You can use a text field for the Value of a crosstab with FIRST or LAST or
MIN or MAX.