Count function in a report (2002)

Is it possible to use the =Count() or DCount() function in textbox on a report to count the number of records in a field called ContractDecision that = "Enroll" or do I have to do the counting in a query?

Re: Count function in a report (2002)

You can use a text box in the report footer or group footer with control source

=Abs(Sum([ContractDecision]="Enroll"))

[ContractDecision]="Enroll" evaluates to True = -1 if the value is "Enroll", and to False = 0 otherwise. Since each record with "Enroll" contributes -1, the Sum is the number of such records but with a minus sign. Abs (absolute value) turns this into a positive number.