Help with Access 97 Formulas

[Guest]

In Access 97, I am trying to put a formula in a report to count the number of
times a specific number shows up in a column. I already have a formula to
count the number of times any number shows up, but I need to know what
formula to use for a specific number in a specific column.

 

[fredg]

In Access 97, I am trying to put a formula in a report to count the number of
times a specific number shows up in a column. I already have a formula to
count the number of times any number shows up, but I need to know what
formula to use for a specific number in a specific column.

In your report, where?
As control source in an Unbound control in the report (except in the
Page Header or Footer:

=Sum(IIf([FieldName]= X,1,0))

where X is the number you wish to count up.

The above is not for the Page Header or Footer. That requires a
different method. See Microsoft KnowledgeBase Article
132017 "How to sum a column of numbers in a report buy page"