hii,

I have created a report with field "Amount" consists of records like shown below.

    Amount
     500.00
     0.00
     600.00
    -700.00
     0.00
     0.00
     100.00

I used count function in report footer text box
    =Count([amount])
    result was 7
I want to count records which are <>0
Is there any function like "CountIf" which is available in Excel

Any help on this

Set the Control Source for the Text Box that displays the count of the Amount to the DCount() Function Ex:

=DCount("[Amount]","[QueryName/TableName]","[Amount]<>0")

Richard