If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining multiple entries
I have data that has donors that have made multiple donations. I want to
combine the donor number so that there is just one instance of it but still have the itemized donations from that donor. I want to do this using a pivot table. I'm running access07 and have already created the pivot table but can't seem to combine the donor number. They show up seperately. e.g. 1414 12/18/2006 December2006 1000 3105 10/13/2006 October 2006 1680 3105 3/10/2006 March 2006 1200 3105 1/24/2006 January 2006 1200 3105 5/1/2006 May 2006 1000 7250 11/21/2006November 2006 5532.68 |
#2
|
|||
|
|||
Combining multiple entries
stetka wrote:
I have data that has donors that have made multiple donations. I want to combine the donor number so that there is just one instance of it but still have the itemized donations from that donor. I want to do this using a pivot table. I'm running access07 and have already created the pivot table but can't seem to combine the donor number. They show up seperately. e.g. 1414 12/18/2006 December2006 1000 3105 10/13/2006 October 2006 1680 3105 3/10/2006 March 2006 1200 3105 1/24/2006 January 2006 1200 3105 5/1/2006 May 2006 1000 7250 11/21/2006November 2006 5532.68 Take the above and show us what result you want to see. Also -- is this a charting question? If not, you might have better luck posting to an Access group. |
Thread Tools | |
Display Modes | |
|
|