Count selected records

  • Thread starter Thread starter pow67
  • Start date Start date
P

pow67

In my report, [PRIMARY INFO], I am trying to count the number of records
where [CITY] = Deerfield.

I have tried several combinations such as:

=Count([PRIMARY INFO].CITY Like "Deerfield")

but this counts all records except null.

Thanks in advance.
CW
 
-----Original Message-----
In my report, [PRIMARY INFO], I am trying to count the number of records
where [CITY] = Deerfield.

I have tried several combinations such as:

=Count([PRIMARY INFO].CITY Like "Deerfield")

but this counts all records except null.

Thanks in advance.
CW
.
Click to expand...
you could try something like this:

=Sum(IIf([CITY]="Deerfield",1,0))

hth
 
You can use DCOUNT to do this =DCOUNT("FIELDNAME","TABLENAME",""FIELDNAME =
'deerfield'")
 
Back
Top