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