Record Count

W

Warren

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?
 
S

Siobhan Perricone

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.
 
A

AlanInBradford

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.
 
G

Guest

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. :)
 
Top