Count subform records where txtCount = 0

  • Thread starter Thread starter bhammer
  • Start date Start date
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))
 
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
 
Back
Top