Counting records

  • Thread starter Thread starter Stephanie
  • Start date Start date
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
 
I don't believe that is going to give you what you want.

Do you want this to show on a form, or do you just want to run the query
and see the number?

If all you want is the number, look at the bottom when the query is in
display mode.
 
Back
Top