Count selected records

[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

 

[tina]

-----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
.

you could try something like this:

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

hth

 

[Tom]

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