brendoaccess
Technical User
Hi
I have two tables that record a one (Donor) to many (Donations) relationship. Most of the Donors in tblDonor make regular donations - each donation has a date, in tblDonations. Having recently undertaken a mailshot I have received many donations from Donors that had been inactive for several years, or had never donated.
The Mailshot was 1 December 08 - I want to know, for all Donations after this date, the length of time between that, and their previous donation (or have something tell me they are a first-time donor).
I can't get it at all - all help appreciated.
Many thanks.
B
I have two tables that record a one (Donor) to many (Donations) relationship. Most of the Donors in tblDonor make regular donations - each donation has a date, in tblDonations. Having recently undertaken a mailshot I have received many donations from Donors that had been inactive for several years, or had never donated.
The Mailshot was 1 December 08 - I want to know, for all Donations after this date, the length of time between that, and their previous donation (or have something tell me they are a first-time donor).
I can't get it at all - all help appreciated.
Many thanks.
B