Jenny6157

No, not a school quesiton:). I'm too old to go to school...lol..The real example is mucho more complicated..I'm just simplifying...

I am working on query to determine if there are missing records in one table, by comparing two tables. Here is a simple example of this below. I am having an issue with it not distiguishing finding any records verses needing all of them to be present to get a "Yes" result..

Table 1 – Team and Members

Team Member

Blue Becky

Blue Tom

Blue George

Red Sam

Red Mike

Table 2 - Members

Member

Becky

Tom

George

Sam

Statement results should return Team name with a Yes - If all members exist in Table 2 that are present in tables one, No - If not all members from Table 1 exist in Table 2

In the example above the results would be:

Team All_Members_Present

Blue Yes

Red No