R robnsd New member Local time Today, 06:59 Joined Oct 29, 2010 Messages 3 Nov 20, 2010 #1 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.
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 Wino Moderator Staff member Local time Today, 06:59 Joined Aug 30, 2003 Messages 36,272 Nov 20, 2010 #2 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
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
D Dairy Farmer Registered User. Local time Today, 16:59 Joined Sep 23, 2010 Messages 244 Nov 21, 2010 #3 A quick and dirty method is to add a column to your query for the report. Code: Counter:iif([field1] = "ABC",1,0) Then in your report add a sum field for this column.
A quick and dirty method is to add a column to your query for the report. Code: Counter:iif([field1] = "ABC",1,0) Then in your report add a sum field for this column.