cancel
Showing results for 
Search instead for 
Did you mean: 

Beginner Question on Where exists (I think)

0 Kudos

I am trying to write a report to count records from Table:Person for the following criteria.

Include the record from Table:Person if the record if that Person has a record in Table:orders for both Apples & Bananas.

DellSC
Active Contributor
0 Kudos

Are you only showing in the report the people who have both Apples and Bananas or are you showing all people and need a count of those who have Apples and Bananas?

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

I am only showing people in the report that have Apples and Bananas (and to clarify each record will only have one type of fruit on it, so for a person to have apples and bananas I they will have two sub records) that's the part that's tripping me up.

Thanks.