Counting Records in report footer

  • Thread starter Thread starter Sam
  • Start date Start date
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?
 
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...
 
Back
Top