count if

S

Steve

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
 
D

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

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
Click to expand...

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