Record Count

  • Thread starter Thread starter Warren
  • Start date Start date
Thanks for your help, but I must not be doing something
right. When I do that, I get a "1" reported in the column
for each record. Any ideas on what I'm doing wrong?
 
How do I get a query to report the number of records that
resulted from the query?
Click to expand...

In your query design window click on the formula button. In the line
called Total: change the drop down for the field you want counted to
COUNT. If you want the information grouped, you need to add the fields
you want it grouped by *before* your count column.

Here's an example:
I have an IP log. I want to know how many times there have been logins
from a particular IP. So I make a query that has the IP field, and the
logged action *twice* (in two columns). I turn on formula, then put
COUNT in the *last* logged action. So it's going to group by IP and by
Logged action, then count each logged action by IP.

Just play around with this a bit and I think you'll get what you're
looking for.
 
That is because you have not clicked the sigma buton to make it an aggregate query.
When you click the sigma sign a row with totals will appear.
That is where you select count from the drop down list.
 
Actually, I did click the Sigma button, and the
application inserts the drop-down which includes "COUNT".
Have you any other suggestions, please? I do appreciate
your efforts in trying to help me. :-)
 
Back
Top