Count subform records where txtCount = 0

[bhammer]

My unbound main form has a header with txtCtIssuesWithoutFiles that I'm
trying to make display the number of records in the subform where the FileCt
column is zero. The FileCt textbox is a calculated field:

=DCount("CitationID","qryCitationsIssues","Issue_ID= IssueID")

Something like:
=Sum(IIf(mySubform.Form.txtFileCt=0,1,0))

 

[Jeanette Cunningham]

Hi bhammer,
my preferred solution for this type of thing is to calculate the answer in
the subform and then just read the final result from the subform.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia