Count subform records where txtCount = 0

B

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))
 
J

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
 
Top