Counting related records only when certain conditions exist
I am trying to do a calculation that counts the number of related records when two conditions exist. In the main table, I have a field called NumberOfRecords which I made a calculation that returns a number. In the related record there are two fields that must have certain data in to be added to the count. Both are dates. The data is inputted from another source.
Date1 can be either "--" or a valid date
Date2 can be either "--" or a valid date
Only records were Date1 = "--" and Date2 = Valid Date should be counted.