I am trying to produce a list of those who donated to our orchestra in FY00 or FY01 *but not* in FY02 and FY03. (FY=Fiscal Year ending)
The query [FY00 or FY01 but not FY02 Donations Query] produces a list of those that donated in FY00 or FY01 but not FY02. However a few of those did give for this year (FY03), and so should be off this list of lapsed donors.
FYI: This query (with the far too long name) draws the member name, etc. from my main table and the donation data from the donation table, which includes every instance of giving by each donating memeber.
My *unsuccessful* attempts at this include:
1) Copying, then ammending the successful query, making it exclude FY02 *and* FY03 donors.
2) Running a query on the first query using the following:
SELECT [FY00 or FY01 but not FY02 Donations Query].TITLE, [FY00 or FY01 but not FY02 Donations Query].FIRSTNAME, [FY00 or FY01 but not FY02 Donations Query].LASTNAME, [FY00 or FY01 but not FY02 Donations Query].Date, [FY00 or FY01 but not FY02 Donations Query].Amount, [FY00 or FY01 but not FY02 Donations Query].[Fiscal Year]
FROM [FY00 or FY01 but not FY02 Donations Query]
WHERE (Donations.[Fiscal Year]="FY03"=False
ORDER BY Master.LASTNAME;
Any ideas?
Thanks.
Aimee
The query [FY00 or FY01 but not FY02 Donations Query] produces a list of those that donated in FY00 or FY01 but not FY02. However a few of those did give for this year (FY03), and so should be off this list of lapsed donors.
FYI: This query (with the far too long name) draws the member name, etc. from my main table and the donation data from the donation table, which includes every instance of giving by each donating memeber.
My *unsuccessful* attempts at this include:
1) Copying, then ammending the successful query, making it exclude FY02 *and* FY03 donors.
2) Running a query on the first query using the following:
SELECT [FY00 or FY01 but not FY02 Donations Query].TITLE, [FY00 or FY01 but not FY02 Donations Query].FIRSTNAME, [FY00 or FY01 but not FY02 Donations Query].LASTNAME, [FY00 or FY01 but not FY02 Donations Query].Date, [FY00 or FY01 but not FY02 Donations Query].Amount, [FY00 or FY01 but not FY02 Donations Query].[Fiscal Year]
FROM [FY00 or FY01 but not FY02 Donations Query]
WHERE (Donations.[Fiscal Year]="FY03"=False
ORDER BY Master.LASTNAME;
Any ideas?
Thanks.
Aimee