Counting records

S

Stephanie

OK - I have a query that shows me only the records I want to see. It's
filtered based on the text in the data. I want to know how many records meet
this criteria. In the Query Design view, I click on the Sum button and
select Count for the Total. I get an error that says Data Type mismatch in
criteria expression. The data is text but I thought Count would give me a
total number of matched records. What am I doing wrong? How can I see the
number of records found? I want to put only this count on a report.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Counting number of records based on criteria 2
Count number of records by date 2
Copy previous record into form field 0
Count of records and Update 3
Access Count query 1
Recordset.clone record count issue 3

Top