Query Consecutive Yearly Payments Access 2007
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!
screenshot.JPG
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!
screenshot.JPG
Rey Obrero (Capricorn1)
what exactly are you trying to do?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I see from your NavigationBar that you have created a crosstab query called 01_Donation_History_Crosst
BTW You may wish to use FIXED COLUMN HEADIONGS in the Crosstab soecifying the years you want and ensuring they are all available despite any other selection criteria you put in the query.
Cheers, Andrew
BTW You may wish to use FIXED COLUMN HEADIONGS in the Crosstab soecifying the years you want and ensuring they are all available despite any other selection criteria you put in the query.
Cheers, Andrew
ASKER
Thanks! worked like a charm! Even better, you got it to list both payments that are consecutive, so i was able to check its validity with the original data.