I have a report which lists weather or not someone has attended an event simply by haveing a Y or N next to that event. I need to have a total at the bottom of the report which counts only the "Y"'s. Anyone know how. I tried =IIF([Present]="Y",Count([Present])) but that didnt work.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need a count at report footer, Quick one!
- Thread starter Tmconsult
- Start date
- Thread starter
- #3
CosmoKramer
Programmer
Try:
=DCount("[Present]", "tblTable", "[Present] = 'Y'"
=DCount("[Present]", "tblTable", "[Present] = 'Y'"
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
