I have an Access 2007 database which contains a list of donations by our patrons. I need to pull a list of donors by account number who have made annual donations in consecutive years of a hundred dollars or more.
The screen shot shows my data from Table1 . I have only managed to pull out the people who have made donations>= 100 dollars. RACCOUNT is the account number, RYEAR=year donation was made, and Donation_Total is the total donations made that year.
Anyways, i've tried creating an extra year field and using count functions but I'm really at a loss of where to start this, Any help would be appreciated, ty!