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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Record Counting Question 1
Dcount -Date Criteria - Won´t find it - 0
Page numbering with Merged Document and IF statements 1
Count, Dcount, or Ab(Sum())? 3
A03 - count in report footer gives me #Error? 0
Count Only Yes checks in Access Report 1
Get Sums for 2 DCount fields on report 1
Help counting multiple checkboxes in a form to make a total in a report 3

Top