Query to return membership NOT renewed for next year

[GizmoRN72]

My alumni database tracks annual memberships, products purchased, donations, meeting attendance, etc. I want to query who paid for a 2019 membership but has not paid for a 2020 membership.

Graduates Table:
GraduateID (Primary Key, AutoNumber, Long Integer);

Products Table:
ProductID (Primary Key, AutoNumber, Long Integer);

Orders Table:
OrderID (Primary Key, AutoNumber, LongInteger), GraduateID (Number, Combo Box "SELECT DISTINCTROW Graduates.* FROM Graduates ORDER BY [Graduates].LastName, FirstName;

Order Detail Table:


OrderDetailID (Primary Key, AutoNumber, Long Integer, OrderID (Number), ProductID (Number, Combo Box "SELECT DISTINCTROW Products.* FROM Products ORDER BY [Products].ProductName

See "Product" Attachment
Product #57 is 2019 Membership
Product #58 is 2020 Membership

See "Relationship" Attachment

Simple query using 57 as ProductID Criteria returns all 2019 Memberships
Simple query using 58 as ProductID Criteria returns all 2020 Memberships
I imported both reports into Excel. To view view sample, See Attachment "2019 & 2010 Membership".

Using query Criteria of '57 And Not 58' only returns names of 2019 Memberships.

Will appreciate any guidance

[Micron]

I'm kind of focused on this at present

Using query Criteria of '57 And Not 58' only returns names of 2019 Memberships.

If you want 57 and don't want 58, then why would you expect anything but 2019? Maybe I'm misunderstanding what you want, but it reads like "show me memberships for 2020" which is 58.

[GizmoRN72]

I want the query to return the graduates who have a 2019 Membership but not a 2020 Membership. For example, looking at the this example ,
I want the query to return GraduateID 631 (Larry Anderson), GraduateID 182 (Martin Andries), and GraduateID 443 (Donna Berringer). They are on the 2019 Membership list but not the 2020 Membership list.

[Micron]

Gotcha. Use the unmatched query wizard to find records that are in one domain but not another. You can use tables or queries as the domains. If all the records are in one table (as I suspect they should be) then use 2 saved queries - one to filter to 2019, the other to filter 2020. The wizard will walk you through the steps.
You might have a problem with your data - 194 has 2 different first names on each side even though the last name is the same.

[GizmoRN72]

Thank You! That is exactly what I wanted. Just saved me much time.

[Micron]

Glad to have been able to help.