Highlight or summarize data based on specific scenarios

Highlight or summarize data based on specific scenarios

I have a cases table (Parent) and a contacts table(child). In the cases table I want to highlight/identify those cases that have any of the following types of contacts.

1. [Outcome of Contact] = Successful, [Contact Type] = In the community (at least 4 instances within a given month)
2. [Outcome of Contact] = Successful, [Contact Type] = In the community (at least 3 instances within a given month) , [Contact Type] = Office (at least 1 instance within a given month)

There is also a "Date of Contact" field within the contacts table that may or may not have ramifications to this request.