Add a control to a report from another query to count records

[Creeker]

I have a report to which I want to add another text box which will display the count of records in a query other than the query the report is based on.

How do I insert that text box and what expression should I use to make it pull in the count of records for that other query?

Would appreciate any suggestions.

 

[CosmoKramer]

Look up the DCount function in Access help. This should accomplish what you're looking for......

 

[Creeker]

Thank you CosmoKramer! You helpef me focus of just what I needed to do. With a little bit of trial and error, it worked!