Summary Query

[khashid via AccessMonster.com]

I need help with a quey. First I have a table that has different columns, two
fields that I want to use are "CSR" and "Responses". these two fields are
lookup and linked with two tables.

Now i need a report based on query, where I can have CSR names on left, and
on top responses, showing the counts. I know I can do it through Pivot Table
but then i can not export it to Excel as simply text.

 

[Guest]

How about a Crosstab Query with CSR as a Row Header, Responses as a Column
Header and Count of Responses as the Value?

This will Export to Excel as data.