count if

[Guest]

Is there a way, (on a report), that I can count only the original records.
For example, the starting contract is "00" the subsequent modification start
at "01" and go up. I have created a report showing all contracts and
modifications but I only want to count the originals. I still want to show
the modifications but only want to cont the originals.

Thank you in advance for and help

Steve

 

[Dean]

One way to do this is to create an expression using the ImmediateIF function
(IIF), iif(contract=00,1,0) then create sum expression in the footer that
sums the results of the expression.

 

[fredg]

Is there a way, (on a report), that I can count only the original records.
For example, the starting contract is "00" the subsequent modification start
at "01" and go up. I have created a report showing all contracts and
modifications but I only want to count the originals. I still want to show
the modifications but only want to cont the originals.

Thank you in advance for and help

Steve

=Sum(IIf([YourField] = "00",1,0))