Count field on report if data exists in subform

  • Thread starter jhicsupt via AccessMonster.com
  • Start date
J

jhicsupt via AccessMonster.com

I have a main form and a sub form and I am trying to write a report based on
these two forms.

On the subform are several titles in field [EETitle]. Corresponding to that
field is [FilledBy].

In the main form, the fields that connect the forms are [ClientName].

So I need to count how many [EETitle]s there are if [FilledBy] is blank. If
no [EETitle], I still want the record to appear in the report, but there
would just be a 0 for number of [EETitle]s.

Thanks in advance.
 
Top