I have a question about a report. I have a report that displays whether an item Passed (P) or Failed (F). At the bottom of the report I want to show how many items Passed (P) and how many Failed (F). I know how to do a Count function in the Expression Builder, but how do you tell it to count the number of items in a field that equal "P" or "F"? Thanks.
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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Expression Builder
- Thread starter WynneSMI
- Start date
In the report footer place 2 text boxes, one for Pass Total and one for the Fail Total.
In the Control Source property enter of the Pass Total:
=DCount("[Pass Fail Fieldname]","Pass Fail Report Recordsource","[Pass Fail Field] = 'Pass' "
In the Control Source property enter of the Fail Total:
=DCount("[Pass Fail Fieldname]","Pass Fail Report Recordsource","[Pass Fail Field] = 'Fail' "
Good Luck Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"
In the Control Source property enter of the Pass Total:
=DCount("[Pass Fail Fieldname]","Pass Fail Report Recordsource","[Pass Fail Field] = 'Pass' "
In the Control Source property enter of the Fail Total:
=DCount("[Pass Fail Fieldname]","Pass Fail Report Recordsource","[Pass Fail Field] = 'Fail' "
Good Luck Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"
- Status
Similar threads
- Locked
- Question
- Locked
- Question