count query

[lmp101010]

I have the following query:



SELECT [CSR List 2].[Last Name], [CSR List 2].[First Name], [CSR List 2].[Active CSR]
FROM [CSR List 2]
WHERE ([CSR List 2].[Active CSR]="Yes");

This is working but I would like to add a column which counts the total results. Any help?

[pkstormy]

In the query design, add an expression column to the query (ie. TotalCount: 1), then change the query to a summarization/Total query (ie. click the funny looking E symbol in the upper menu - you'll then see a new "Total" row under each column) and then change the TotalCount: 1 column to SUM (where the other ones will be GROUP BY and your [Active CSR] column will be a WHERE.)