Query to find most recent donations

[KACJR]

Greetings to the well of knowledge...

I need some assistance in building a query or programming some VBA logic that will allow me to do the following...

I have a table of donations made to our organization. There are many instances where the same individual has made multiple donations over time. Shown below is a sample of dummy data...

IndexedName	LastDonationNumeric	FormattedDate	LastDonationAmount
///Fidelity Charitable Gift Fund	41330	02/25/2013	50
///Fidelity Charitable Gift Fund	41859	08/08/2014	100
Aardvark/Aaron//	41748	04/19/2014	100
Aardvark/Aaron//	41984	12/11/2014	100
Anteater/Allison//	41752	04/23/2014	5
Anteater/Allison//	41895	09/13/2014	3
Badger/Barry//	41700	03/02/2014	145
Badger/Barry//	41993	12/20/2014	500
Beaver/Boris//	41270	12/27/2012	200
Beaver/Boris//	41635	12/27/2013	300
Beaver/Boris//	41963	11/20/2014	200
Cumberbatch/Benedict//	41509	08/23/2013	100
Cumberbatch/Benedict//	41647	01/08/2014	25
Cumberbatch/Benedict//	41861	08/10/2014	50
Cumberbatch/Benedict//	41902	09/20/2014	100
Doe/John//	41638	12/30/2013	50
Doe/John//	41821	07/01/2014	50
Doe/John//	41991	12/18/2014	60
Lincoln/Abraham//	41640	01/01/2014	25
Lincoln/Abraham//	41760	05/01/2014	25
Lincoln/Abraham//	41883	09/01/2014	25
Public/James/Q/	41289	01/15/2013	200
Public/James/Q/	41642	01/03/2014	100
Public/James/Q/	41920	10/08/2014	100
Public/James/Q/	41988	12/15/2014	100
Tuna/Charlie//	41637	12/29/2013	100
Tuna/Charlie//	41891	09/09/2014	125
Tuna/Charlie//	41987	12/14/2014	50
Vandersmoot/Linus//	41079	06/19/2012	100
Vandersmoot/Linus//	41774	05/15/2014	250
Vandersmoot/Linus//	41911	09/29/2014	150

What I need to do is find the last donation made by each individual and plant this data into a new table. The last donation date is the "LastDonationNumeric" field (the FormattedDate field is text). So at the end of all this, I need a table that contains...

IndexedName	LastDonationNumeric	FormattedDate	LastDonationAmount
///Fidelity Charitable Gift Fund	41859	08/08/2014	100
Aardvark/Aaron//	41984	12/11/2014	100
Anteater/Allison//	41895	09/13/2014	3
Badger/Barry//	41993	12/20/2014	500
Beaver/Boris//	41963	11/20/2014	200
Cumberbatch/Benedict//	41902	09/20/2014	100
Doe/John//	41991	12/18/2014	60
Lincoln/Abraham//	41883	09/01/2014	25
Public/James/Q/	41988	12/15/2014	100
Tuna/Charlie//	41987	12/14/2014	50
Vandersmoot/Linus//	41911	09/29/2014	150

Any help is greatly appreciated...

Regards,
Ken Carter
TILL, Inc.

[June7]

Consider TOP N query: http://allenbrowne.com/subquery-01.html#TopN

Why bother writing to another table? Just use the query.

[KACJR]

Thanks! This was most helpful!