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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to count a subset of records?
Thanks rjoubert. I tried your suggestion, then tried =DCount("[FledgeNumber]","Name Of Query Report is Based on","[FledgeNumber]>0") and =DCount("[FledgeNumber]","Name Of Query Report is Based on","[FledgeNumber]<>0") All gave "#Error" in the report. I then created a new query that only...- naw2
- Post #3
- Forum: Microsoft: Access Reports
-
How to count a subset of records?
I have a report with bird nests and number of chicks. I created a calculated control that counts the number of total nests. The control source is =(Count([FledgeNumber])). When I run, I get: Year TerritoryName FledgeNumber 1996 Nest1 2 1996 Nest2 0 Total Number...- naw2
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
