I have a database with 2 tables: one with name/address info, and another with info on yearly donations to our organization. The 2 tables are linked through an ID number. I have set up a query that will give me name/address info for those who donated in 2010 (where the year field is 2010 and the contribution fields are >0) that will be used in a report that makes mailing labels. I want separate mailing labels for everyone else. Is there a way to set up a query that excludes the results of a previous query? There are too many variables to have a simple query that is the opposite of the first one (2010 = 0, for instance) because if someone didn’t donate in 2010, 2010 doesn’t appear in their record. Also, many people who donated in 2010 also donated in previous years, and I don’t want their names repeated. I’ve tried as many things as I can think of, to no avail! Any help would be greatly appreciated.
November 17, 2010 7:37 PM
November 17, 2010 8:36 PM