I have a table of donors, the name and address is repeated up to 10 times with the date of the gift and the dollar amount of the gift different in each record.
John Adams 123 anystreet 9/10/08 $100
John Adams 123 anystreet 6/06/08 $50
John Adams 123 anystreet 3/15/08 $100
John Adams 123 anystreet 5/12/08 $50
what I want is a table that has
John Adams = a) 9/10/08 100 b) 6/06/08 50 c) 3/15/08 100
In date order preferably.
Anyone know a simple way to go about this. We are going to eventually print letters in Word showing the name and address + the amounts they donated with the dates listed in the body. The most I found is one person making 10 donations.
Thanks.
John Adams 123 anystreet 9/10/08 $100
John Adams 123 anystreet 6/06/08 $50
John Adams 123 anystreet 3/15/08 $100
John Adams 123 anystreet 5/12/08 $50
what I want is a table that has
John Adams = a) 9/10/08 100 b) 6/06/08 50 c) 3/15/08 100
In date order preferably.
Anyone know a simple way to go about this. We are going to eventually print letters in Word showing the name and address + the amounts they donated with the dates listed in the body. The most I found is one person making 10 donations.
Thanks.