G
Guest
HI-
I have two tables 1. Donor information (with fields: ID, last name, first
name) and 2. Donations (with fields: ID, gift date, gift amount). I have set
up a one to many relationship between the two, where there can only be one
donor but that donor can make several donations. I have generated a
report, using a cross-tab query, that list all the donors down the left hand
column, and then their donations by year across. I then total the sum of
donations per person and per year. I also count the number of donations per
year. I am trying to figure out how to count the number of FIRST TIME DONORS
per year, any idea on how to do this?
Any help would be greatly appreciated!!!!
Thanks
I have two tables 1. Donor information (with fields: ID, last name, first
name) and 2. Donations (with fields: ID, gift date, gift amount). I have set
up a one to many relationship between the two, where there can only be one
donor but that donor can make several donations. I have generated a
report, using a cross-tab query, that list all the donors down the left hand
column, and then their donations by year across. I then total the sum of
donations per person and per year. I also count the number of donations per
year. I am trying to figure out how to count the number of FIRST TIME DONORS
per year, any idea on how to do this?
Any help would be greatly appreciated!!!!
Thanks