Counting in Report

S

Shadow

Go to Access Help & search for DCount function.

I use the following statement in a Report Footer to count
and print out the number of yes entries in a yes/no field
named 'RemoveBitterbrush' in a table 'tblPermitData':

=DCount
("[RemoveBitterbrush]","tblPermitData","[RemoveBitterbrush]
= Yes ")

You could substitute 1 & 2 for Yes
 
Top