count records of a particular value

[robnsd]

I want to see the number of records where a field equals a particular value in my report. I know of the count records function but it counts all records. How do I only count partucular records.

 

[pbaldy]

A DCount() is one way, a totals query is another. Either would need the appropriate criteria. More info here:

http://www.mvps.org/access/general/gen0018.htm

 

[Dairy Farmer]

A quick and dirty method is to add a column to your query for the report.

Counter:iif([field1] = "ABC",1,0)

Then in your report add a sum field for this column.