Using the Count function in a cross-tab query

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with COUNT in Query 2
create new expression?field? in a query based on two fields 5
Display a count of unique records in a query in Access 2007 6
Use count function to ignore duplicate entries and create new vari 2
Show Duplicate records only once 3
Query of donors by number of donations made 5
Append Query Major Complication 11
Receipt Numbering in Append Query 4

Top