Counting records?

D

Daniel P. Cayea

What is the best way to count records with a certain criteria? For example
if I have a list of computers broken down into system units, displays, etc,
how can I get it to give me a count of only system units or only displays?

Thanks,
Dan
 
D

Daniel P. Cayea

The table name is "Demographics" and the field name is "Category".

Thanks,
Dan
 
D

Daniel P. Cayea

Thanks Steve. I'm in the query design view but don't see where I change
"Group By" to "Where".
 
J

John Spencer

You missed a step.

== Add your table to a query
== Add the Category field to the field three times
== Select View: Totals from the menu
== Under the second category field change GROUP BY to Count
== Under the third category field change Group by to WHERE
== Enter the value you are looking for in the criteria under the third
instance of the field. If you want to see ALL the category counts at
once enter Like "*" or eliminate the third column completely.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
6

666237

Steve said:
Dan,

Did you change the query to a Toyals query by clicking on the Sigma button
in the menu at the top of the screen? If you did, then when you go to
Group By, a down arrow appears at the right of Group By. Click this arrow
and a drop down list appears. Select Where or Count as needed.

Steve
Click to expand...
 
Top