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