Counting records?

  • Thread starter Thread starter Daniel P. Cayea
  • Start date Start date
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
 
Thanks Steve. I'm in the query design view but don't see where I change
"Group By" to "Where".
 
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
'====================================================
 
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...
 
Back
Top