Counting Records in report footer

S

Sam

I am trying to count records in the report footer when a certain condition
exist when calculating the difference between two fields, ie ([field
1]-[field 2]) = 0. Only count the records that match the results. Any
suggestions?
 
C

Clifford Bass

Hi Sam,

Try something like: =Sum(IIf([field 1] = [field 2], 1, 0))

Clifford Bass
 
S

Sam

Thanks Cliff, the formula works fine and does exactly what I need.

Clifford Bass said:
Hi Sam,

Try something like: =Sum(IIf([field 1] = [field 2], 1, 0))

Clifford Bass

Sam said:
I am trying to count records in the report footer when a certain condition
exist when calculating the difference between two fields, ie ([field
1]-[field 2]) = 0. Only count the records that match the results. Any
suggestions?
Click to expand...
Click to expand...
 
Top