Count of records that have been filtered in a query

[singingshiver]

I have created a query based on my form to show only my records that are in a "monitoring" state. How can I get a total displayed for the number of records it shows? I have a form based on this query and ultimately I want the total displayed in a report I have already created.

Any help would be appreciated.

 

[bertusvanrooy]

I think a simple way of doing this would be to add a TEXTBOX control on your form or report and setting the Control Source property to "=Count(*)".

This should count all the records in the active recordset and return the result to your TEXTBOX control.

Cheers,

 

[singingshiver]

Didn't work

Thanks for the reply.

I tried what you suggested but it didnt work: "=Count(*)".

Any other suggestions?

 

[Rich]

Without the quotes?

 

[bertusvanrooy]

That's correct. See the attachment for a sample.

Cheers,

 

[singingshiver]

WORKS

IT WORKS!!!

I re-created the query and form and now it works. Thanks very much everyone.