Count(number of records) is asking to "Enter A Parameter Value"

[accessmatt]

Hello,

I'm writing a query that pulls in the count of records from another query. For some reason it's asking me to Enter A Value. When I do, they query runs. However, I want the query to show the counts from my other query without having the prompt appear. Any ideas why this is happening and how to correct?

Thanks,

[ranman256]

This means the field does not exist in the table. (either because of spelling or reference)
Dont use COUNT() in a query...the query does the counting using the SUM ftn in totals grouping.

[accessmatt]

ranman256 - thank you but I want to count (or sum) the number of records in another query (called query 2) and pull that into a field in query 1. What am I missing?

[accessmatt]

ranman256, I was able to fix this myself by joining the tables I wanted to use together! thanks,