count is not correct.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a query that runs off a form that is supposed to count the number
of status fields, in a query which also happens to be called status. it
should count 2 but it counts 90? I have no idea where it is getting such a
number. in the design grid for the count query I have:
field:status
Table:status
total:count

that's about as easy and straight forward as I can make it.
I would love to get any suggestions. I appreciate this.
nick
 
The count function will actually count the number of records in the status
table where your status field is not null.

What are the values in your status field?

Do you want to count all the records, or only ones with specific values?

Dale
 
Back
Top