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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top