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.
 
You must log in or register to reply here.

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

Access Dcount (multiple criteria) 3
Count of records and Update 3
Counting number of records based on criteria 2
SIMPLE QUESTION MAYBE? need to count records BUT only records that 2
Access Counting records based on multiple age bracket and output to tabulated report 0
Show counts on form 2
Access Dcount function in access 0
Continuous form - Counting records based on criteria 2

Back
Top