Counting records?

[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

 

[Roger Carlson]

It would be easier to answer if you gave table and field names.

However, in a query, you could do something like:

Select Count(*) From YourTableName Where YourFieldName = "system";

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Daniel P. Cayea]

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

Thanks,
Dan

 

[kate]

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

Thanks,
Dan

 

[kate]

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

Thanks,
Dan

 

[kate]

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

Thanks,
Dan

 

[Daniel P. Cayea]

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

 

[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
'====================================================

 

[666237]

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