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?

[Datagopherdan]

Do you mean the total results within that query? You can create an unbound text box with a DCount Function e.g. DCount("*","MyQuery")

[lmp101010]

Thanks for you help! Can you tell me how to create and unbound text box?

[Datagopherdan]

You just select textbox from the controlbox. That's all there is to it.

Thanks for you help! Can you tell me how to create and unbound text box?

[lmp101010]

Thanks for your help. I attempted your instructions by adding a calculated text box to the form. Then I put in the function that you recommended DCount("*","MyQuery"). I got a pop up asking me to enter a parameter value. I assumed the "My Query" was just a placeholder and changed it to "Current CS Member" which is the value that I want to count. (In other words I have a long list of "Current CS Members" and I am trying to count them). I still received the same "enter parameter value" error. Any clues what I'm doing wrong. Thanks again for your help!

[Rawb]

"My Query" should be your SQL Statement. If you've saved your Query as a Query Object in Access, you can use that name as well: For example. . .

You have a query called qryMySelect

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");

You would use

=DCount("*","qryMySelect")

[lmp101010]

That works. Thanks!