Hello, and thanks in advance to all and any with advice,

1) I have a database that was built for tracking donors and donations to an organization. The database has two tables that I am concerned with: "Donors' and "donations" A donor can have more than one donation linked to them, but obviously, one donation cannot have multiple donors. The database is riddled with duplicate donors that have distinct donations attached to them. I have been asked to combine these donors, so that all corresponding donations are related to a single donor. Does this make sense? Any thoughts? An additional challenge is that many of the duplicates are because donors identify only themselves in one donation and upon a second donation identify themselves and a spouse. Any thoughts on how to accommodate for this variation?  
2)  Once I get these tasks taken care of, my job is to create a thank you letter that can be generated in Access for every new donation. Any direction on this would be greatly appreciated.
I really appreciate any help or direction!
Bob

---

Reply from Alex Hedley:

There is find duplicates query wizard
You could use the LIKE keyword in a Query then *NAME* to find partial names


Tip on Mass Mail


Email Seminar